SQL to Copy Table from One Session to Another?

Jeffrey Jones jjones at synergos.com
Wed Jan 26 16:24:41 UTC 2022


Saw a tool once for doing this.

https://www.withdata.com/sqlitetopostgres/

> On Jan 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