Have you tried this approach: http://web2py.com/books/default/chapter/29/06/the-database-abstraction-layer#CSV--all-tables-at-once-
It will generate new ids but still maintain all references. Anthony On Sunday, January 17, 2016 at 1:20:10 PM UTC-5, Alex Glaros wrote: > > sorry Denes, I forgot to explain that I'm migrating to Postgres and doing > all tables at once. Would like to automate the ."id" removal. Any ideas > on that? > > for table in db.tables: > rows = db(db[table]).select() > table_name = str([table]) + '.csv' > rows.export_to_csv_file(open(table_name, 'wb')) > > thanks > > Alex > -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Source code) - https://code.google.com/p/web2py/issues/list (Report Issues) --- You received this message because you are subscribed to the Google Groups "web2py-users" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. For more options, visit https://groups.google.com/d/optout.
