KLEIN Stéphane wrote: > Le Wed, 01 Aug 2007 11:27:39 -0400, Carsten Haese a écrit : > >> On Wed, 2007-08-01 at 14:49 +0000, KLEIN Stéphane wrote: >>> Hello, >>> >>> I wonder if there are module,class to perform table copy ? Coping table >>> structure and/or table data from one database to other or same. >> You have a much better chance of getting a helpful answer if you told us >> what your database server is. Oracle, Sql server, Informix, PostgreSQL, >> MySQL, ...? > > Currently, it's MySQL and PostgreSQL. First, I thought abstract database > tools. > > Stephane > > _______________________________________________ > DB-SIG maillist - DB-SIG@python.org > http://mail.python.org/mailman/listinfo/db-sig
Most databases that I've used support the statement "CREATE TABLE AS". e.g. take a look at page 890 of the PostgreSQL 8.1 manual. Regards, Andy -- From the desk of Andrew J Todd esq - http://www.halfcooked.com/ _______________________________________________ DB-SIG maillist - DB-SIG@python.org http://mail.python.org/mailman/listinfo/db-sig