The concept is applicable to any number of tables. Tables store the names of their fields in db.table.fields so you can create a copy of that without the id field (or any other(s)) an use it to select the rows in your program.
Denes 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.
