News for hackers. Stuff that matters.
Re:Microsoft's “Love” of Linux by Nullabillity on Friday November 22, 2019 @01:10AM (#21603220)
> 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

[1]: https://www.postgresql.org/docs/current/sql-copy.html

[2]: https://www.postgresql.org/docs/current/app-psql.html#APP-PS...

There are no comments on this comment yet.