[ADMIN] copy table

2010-02-08 Thread Marc Fromm
I created a new database and I want to copy a table from a different database into the new database. 1. I used phpPgAdmin and exported the table that I want a copy of. 2. In the new database I pasted the export into the SQL box in phpPgAdmin and clicked execute to create the table. The table was

Re: [ADMIN] copy table

2010-02-08 Thread Melissa Peterson
Subject: [ADMIN] copy table I created a new database and I want to copy a table from a different database into the new database. 1. I used phpPgAdmin and exported the table that I want a copy of. 2. In the new database I pasted the export into the SQL box in phpPgAdmin and clicked execute to create

[ADMIN] Copy table to table

2008-05-23 Thread Suresh Gupta VG
Hi List, I want to create a new table with the data and constraints as it is from existing table. I could create a new table with the existing table data as create table test2 as select * from test1; . Here the constraints are not copying. Can any one please show me the way. Regards,