[sqlite] convert a PostgreSQL to sqlite

2015-07-06 Thread da...@dandymadeproductions.com
c.buhtz wrote: > Is there a way (free, open source, Ubuntu) to convert a > PostgreSQL-database with data in it to a sqlite database? Hello, 1. Download the free open source Java application MyJSQLView. http://myjsqlview.com/download.html 2. Insure the PostgreSQL JDBC driver is installed in

[sqlite] convert a PostgreSQL to sqlite

2015-07-06 Thread Eduardo Morras
On Sun, 5 Jul 2015 14:44:00 +0200 wrote: > Is there a way (free, open source, Ubuntu) to convert a > PostgreSQL-database with data in it to a sqlite database? Check VirtualPG virtual table extension, https://www.gaia-gis.it/fossil/virtualpg/index It permits create and fill a virtual table in

[sqlite] convert a PostgreSQL to sqlite

2015-07-06 Thread c.bu...@posteo.jp
On 2015-07-05 17:40 Jim Callahan wrote: > Are you using an PostgreSQL add-ins such as "PostGIS" or an object > relational mapper? I know nothing about GIS. I access the db with SQLAlchemy in Python3.

[sqlite] convert a PostgreSQL to sqlite

2015-07-05 Thread Simon Slavin
On 5 Jul 2015, at 1:44pm, c.buhtz at posteo.jp wrote: > Is there a way (free, open source, Ubuntu) to convert a > PostgreSQL-database with data in it to a sqlite database? Dump the Postgres database to a text file of SQL commands. Then use the SQLite command-line tool to .read that text file.

[sqlite] convert a PostgreSQL to sqlite

2015-07-05 Thread Jim Callahan
Are you using an PostgreSQL add-ins such as "PostGIS" or an object relational mapper? In that case I would recommend an intermediate program or language. For example, if you are using the PostGIS add-in I would recommend going through a GIS program such as ESRI's ArcGIS or the open source QGIS.

[sqlite] convert a PostgreSQL to sqlite

2015-07-05 Thread Jim Callahan
Welcome to SQLite3! Make sure SQLite3 is appropriate for your use; for some use cases a client-server database like PostgreSQL is recommended: "Situations Where A Client/Server RDBMS May Work Better ...If there are many client programs sending SQL to the same database over a network, then use a

[sqlite] convert a PostgreSQL to sqlite

2015-07-05 Thread John McKown
On Sun, Jul 5, 2015 at 7:44 AM, wrote: > Is there a way (free, open source, Ubuntu) to convert a > PostgreSQL-database with data in it to a sqlite database? > If you're looking for something already done, I am not aware of anything that will do that "out of the box" convertPGtoSQLite

[sqlite] convert a PostgreSQL to sqlite

2015-07-05 Thread c.bu...@posteo.jp
Is there a way (free, open source, Ubuntu) to convert a PostgreSQL-database with data in it to a sqlite database?