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
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
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.
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.
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.
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
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
Is there a way (free, open source, Ubuntu) to convert a
PostgreSQL-database with data in it to a sqlite database?
8 matches
Mail list logo