/usr/pgsql-11/bin/pg_dumpall -p 5432 -U postgres -r | /usr/pgsql-11/bin/psql -p 5433
Related Posts
entity-attribute-value design in PostgreSQL – don’t do it! – CYBERTEC
Customers have often asked me what I think of “Entity-attribute-value” (EAV) design. So I thought it would be a good idea to lay down my […]
Datazo V
SELECT unnest(string_to_array(‘1,2,3,4’, ‘,’)) un string lo transformas a un array y el unnest te lo pone en filitas… bien tecnico Saludos,
Copiar una base de datos en Postgres
Para copiar una base, primero hay que tenerla sin usuarios conectados… los sacamos: SELECT pg_terminate_backend(pid) –* FROM pg_stat_activity WHERE pid <> pg_backend_pid() –and query = […]