Re: From SQLite to Postgres

From: Rich Shepard <rshepard(at)appl-ecosys(dot)com>
To: pdxpug(at)postgresql(dot)org
Subject: Re: From SQLite to Postgres
Date: 2011-02-16 19:10:37
Message-ID: alpine.LNX.2.00.1102161108100.19529@salmo.appl-ecosys.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pdxpug

On Wed, 16 Feb 2011, Joshua D. Drake wrote:

> That will create your table.

Josh,

Yep. I need to get rid of the single and double quotes and change the
attribute separators in case there's a string with a comma in it.

I suppose that I don't need the PRAGMA statement, either.

On my system with 4G RAM emacs cramped and barfed trying to replace all
',' with ':'; too many changes. I'll split the file into smaller chunks,
massage each chunk, then re-assemble it.

Thanks,

Rich

In response to

Browse pdxpug by date

  From Date Subject
Next Message Rich Shepard 2011-02-16 21:13:14 Spaces in .sql File
Previous Message Rich Shepard 2011-02-16 19:07:44 Re: From SQLite to Postgres