8 ms·
> 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
by 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...