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
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
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,