SQL to Copy Table from One Session to Another?

Doug Easterbrook doug at artsman.com
Wed Jan 26 16:52:12 UTC 2022

I’d dump the table to a flat file in sql-lite in the format that you use pg_restore or SQL to load the table back up

here’s somethinf on stack overflow to help

https://stackoverflow.com/questions/758945/whats-the-fastest-way-to-do-a-bulk-insert-into-postgres <https://stackoverflow.com/questions/758945/whats-the-fastest-way-to-do-a-bulk-insert-into-postgres>

just make a text file that has one insert    and many rows of values

use PSQL to process it

Doug Easterbrook
Arts Management Systems Ltd.
mailto:doug at artsman.com
Phone (403) 650-1978

> On January 26, 2022, at 8:09 AM, Das Goravani <goravanis at gmail.com> wrote:
> Hello $all,
> I have a database table with 1.7 million cities worldwide in it. It’s about 1.5 GB of data. I have it in a SQLite Database in one session within Omnis.
> Then I have a Postgres session going on too.
> I would like to copy the whole database table from SQLite to Postgres.
> I have seen it covered before how one can do this with SQL commands, I think.
> Can you do it with SQL Commands? I’m puzzled by the fact that they are in two different sessions.
> Das
> _____________________________________________________________
> Manage your list subscriptions at http://lists.omnis-dev.com
> Start a new message -> mailto:omnisdev-en at lists.omnis-dev.com 

More information about the omnisdev-en mailing list