From: Doug B. <dou...@gm...> - 2011-08-01 18:22:36
|
Thanks, Martin! That should be useful for anyone going from SQLite to Postgresql. BTW, the Gramps Django export will go to Postgresql directly, but those tables are not that useful outside of Django. -Doug On Mon, Aug 1, 2011 at 12:59 PM, Martin Steer <mar...@ma...> wrote: > I post this here in the off chance that it may be useful to someone. > > I wanted some test data for a postgres project of mine, so exported my > gramps db to sqlite, then dumped that to SQL text for import into pg. I > had to clean up the text dump for pg import, as follows: > > remove quotes from the table name in insert statements > > pg requires boolean values to be quoted, change column type to int for > affected tables (can change them back once inside pg) > > change illegal column name 'desc' in the media and url tables > > change illegal column name 'type' in the lds table > > change faulty column type TXT to TEXT for url(desc) and > datamap(value_field) > > change col type from CHARACTER(25) for source_ref(page) (too short for the data) > > ------------------------------------------------------------------------------ > BlackBerry® DevCon Americas, Oct. 18-20, San Francisco, CA > The must-attend event for mobile developers. Connect with experts. > Get tools for creating Super Apps. See the latest technologies. > Sessions, hands-on labs, demos & much more. Register early & save! > http://p.sf.net/sfu/rim-blackberry-1 > _______________________________________________ > Gramps-devel mailing list > Gra...@li... > https://lists.sourceforge.net/lists/listinfo/gramps-devel > |