On Thu, 17 Nov 2005, Robert Leftwich wrote:
>Is it still the case that 'the text format used is the same as used by
>PostgreSQL' as described at http://sqlite.org/sqlite.html? I'm trying to import
>some data from Postgres using the approach described there i.e.
>
> sqlite ex3 <schema.sql
> pg_dump -a ex2 | sqlite ex3
>
>and it is failing with a lot of errors, such as SQL error: unrecognized token:
>"\".
>
>I've tried with both sqlite v2.8.15 and 3.0.8 against Postgres 8.01 w/o
>success.
The above is really not enough to go on.
We need more information on your:
- Schema
- Data
- Sample output from pg_dump
>
>Robert
>
>
--
/"\
\ / ASCII RIBBON CAMPAIGN - AGAINST HTML MAIL
X - AGAINST MS ATTACHMENTS
/ \