https://stackoverflow.com/questions/15266345/loop-on-tables-with-pl-pgsql-in-postgres-9-0
https://makandracards.com/zeroglosa/19659-comando-execute-para-dinamismo-no-postgresql
Arquivo da categoria: Banco de Dados
How To Delete Duplicate Rows in PostgreSQL
PostgreSQL ODBC Driver (psqlODBC) connection strings
GTID_PURGED variable makes mysql dump non backward compatible
Rails + Postgres drop error: database is being accessed by other users
Easy and scalable solution for mysql database backup to AWS S3 bucket
Mysql2::Error: Out of sort memory, consider increasing server sort buffer size using docker-compose.yml
[MY-013131] [Server] Out of sort memory, consider increasing server sort buffer size!
SET GLOBAL sort_buffer_size = 1024 * 1024 * 4;DUMP do MongoDB
mongodump --host $HOST --port 27017 --username $USER --db $DB_NAME --password $PASSWORD --out $BACKUPROOT --authenticationDatabase admin --authenticationMechanism SCRAM-SHA-1MongoDB user dando permissão
db.createUser({
user: '<user>',
pwd: '<password>',
roles: ["userAdminAnyDatabase",
"dbAdminAnyDatabase",
"readWriteAnyDatabase"]
})