3 ms·

What about copying data between databases? I couldnt get it right in pg, meanwhile works fine in SQL Server Also pgAdmin has no(?) Intellisense.

• Nullabillity 7y ago
  > What about copying data between databases? I couldnt get it right in pg, meanwhile works fine in SQL Server Export to SQL with pg_dump[0], or export to CSV with COPY[1] or \copy[2]. > Also pgAdmin has no(?) Intellisense. Press ctrl+space for auto-complete. It also seems to pop up when you press `.` (in a valid place). psql follows the more typical convention of auto-completing on tab. [0]: https://www.postgresql.org/docs/12/app-pgdump.html https://www.postgresql.org/docs/12/app-pgdump.html [1]: https://www.postgresql.org/docs/current/sql-copy.html https://www.postgresql.org/docs/current/sql-copy.html [2]: https://www.postgresql.org/docs/current/app-psql.html#APP-PSQL-META-COMMANDS-COPY https://www.postgresql.org/docs/current/app-psql.html#APP-PS...