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.
Thanks for that - I will try that approach next and report back.
I managed to import using the COPY on v2.8, after manually removing the column
list(s) in the pg_dump generated COPY commands. It was fairly slow, but it is a
large data set (2 of the tables have around a million rows - FWIW I'm looking at
using sqlite as the backend for demos/laptops).
Robert
