[DB-SIG] I wonder if there are module, class to perform table copy ?

[Andy Todd]

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 at 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/