Ed Singleton schrieb: > If not does anyone know any other way to convert postgres's sql to sql > suitable for sqlite?
I have not tried this, but if your model isn't too complex: - change the database URL in your project's config file to point to a non-existent SQLite database - do 'tg-admin sql create' - Dump your Postgres database with pg_dump --attribute-inserts --no-owner --no-privileges --data-only mydb >data.sql - Import into the SQLite database with 'sqlite3 db.sqlite <data.sql' Since SQLite doesn't know anything about the different data types, this should work. I don't know about DATE etc. columns though. HTH, Chris --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "TurboGears" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/turbogears?hl=en -~----------~----~----~----~------~----~------~--~---
