On Dec 5, 2005, at 6:05 PM, Mark Harrison wrote:
Right now I'm going over the output of "psql -echo-hidden" to see how to pull the appropriate schema information from postgresql. The final output will be sqlite statements to create tables which mirror the structure in the master postgresql database.
You might be able to use pg_dump to get what you need - it can dump the schema with or without data. In fact prior to SQLite 3.0, SQLite had support for directly reading pg_dump output. For simple schemas it would probably work fine. Just be sure to use the -d option if you decide to dump data and you are using SQLite 3.0 or later.
http://www.postgresql.org/docs/8.1/interactive/app-pgdump.html http://www.sqlite.org/lang_copy.html John DeSoi, Ph.D. http://pgedit.com/ Power Tools for PostgreSQL
