John DeSoi wrote:
On Nov 17, 2005, at 3:53 PM, Robert Leftwich wrote:
Well, the question was intended to find out if the documentation was
accurate, i.e. should it work as described. If not, then I wouldn't
waste any more of the lists or my time on it. That said, it doesn't
seem to matter what data I throw at it, it fails every time. Here is
the unedited output from 'pg_dump -a' for a test database:
If you use the -d (or -D) option to pg_dump you'll get INSERT
statements rather than COPY. This is more likely to work with SQLite.
John DeSoi, Ph.D.
http://pgedit.com/
Power Tools for PostgreSQL
a quick pg_dump --help will show that you can dump the schema by itself
also, you could make whatever minor changes you need, load the schema to
sqlite, then load data from the pg_dump -d/D .
if you're interested,,,
RUBY and Og can also be setup to dynamically load the schema/data from
one DB to the other..
