Re: [GENERAL] Transforming pg_dump output to be compatible with SQLite 3.x

2014-08-29 Thread John McKown
You're correct. It is Friday leading to a 3 day weekend here. And it is a short work day too. So my brain has definitely already left the building. Thanks for pointing that out. I use SQLite some, but just for very basic stuff and am not really familiar with it. Perhaps Kynn could show what, in par

Re: [GENERAL] Transforming pg_dump output to be compatible with SQLite 3.x

2014-08-29 Thread Adrian Klaver
On 08/29/2014 07:40 AM, John McKown wrote: On Fri, Aug 29, 2014 at 9:06 AM, Kynn Jones wrote: Greetings! I'm looking for tools/resources/ideas for making pg_dump's output compatible with SQLite v. 3.1.3. Ideally, I'd love to be able to do something like this (Unix): % rm -f mydatabase.db

Re: [GENERAL] Transforming pg_dump output to be compatible with SQLite 3.x

2014-08-29 Thread John McKown
On Fri, Aug 29, 2014 at 9:06 AM, Kynn Jones wrote: > Greetings! > > I'm looking for tools/resources/ideas for making pg_dump's output compatible > with SQLite v. 3.1.3. > > Ideally, I'd love to be able to do something like this (Unix): > > % rm -f mydatabase.db > % pg_dump --no-owner --inserts

[GENERAL] Transforming pg_dump output to be compatible with SQLite 3.x

2014-08-29 Thread Kynn Jones
Greetings! I'm looking for tools/resources/ideas for making pg_dump's output compatible with SQLite v. 3.1.3. Ideally, I'd love to be able to do something like this (Unix): % rm -f mydatabase.db % pg_dump --no-owner --inserts mydatabase | pg_dump2sqlite3 | sqlite3 mydatabase.db ...where pg_