Skip site navigation (1) Skip section navigation (2)

Copy table to table

From: "Suresh Gupta VG" <suresh(dot)g(at)zensar(dot)com>
To: <pgsql-admin(at)postgresql(dot)org>,<pgsql-admin-owner(at)postgresql(dot)org>
Subject: Copy table to table
Date: 2008-05-23 08:16:03
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-admin
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.  



G. V. Suresh Gupta


Innovative Technology Solutions(ITS), Zensar Technologies 

Zensar Knowledge Park, Plot#5, MIDC IT Tower, 

Kharadi, Off Nagar Road, Pune - 411014

Landline :  +91-20-66453471           | +91-9890898688                 

Email     :   suresh(dot)g(at)zensar(dot)com    | website:



This email may contain confidential or privileged information for the intended recipient(s) and the views expressed in the same are not necessarily the views of Zensar Technologies Ltd. If you are not the intended recipient or have received this e-mail by error, its use is strictly prohibited, please delete the e-mail and notify the sender. Zensar Technologies Ltd. does not accept any liability for virus infected mails. 

pgsql-admin by date

Next:From: Graeme GouldDate: 2008-05-23 11:32:37
Subject: pgpass.conf
Previous:From: Amit jainDate: 2008-05-23 06:13:12
Subject: Re: Error while executing pg_dump "invalid memory alloc request size 4294967293"

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group