From: | Jan Poslusny <pajout(at)gingerall(dot)cz> |
---|---|
To: | Sally Sally <dedeb17(at)hotmail(dot)com> |
Cc: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: making a copy of a table within the same database |
Date: | 2004-03-03 15:19:19 |
Message-ID: | 4045F777.8010902@gingerall.cz |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
create table newtable as select * from oldtable;
:)
Sally Sally wrote:
> I wanted to dump the contents of one table to another (with a
> different name) within the same database. I am looking at pg_restore
> and it doesn't seem to have the option of specifying the name of the
> table we want to dump to, only the name we want to dump from. Does
> this mean I have to create the table and do an sql statement to copy
> the table? Is this the best way?
> Sally
>
> _________________________________________________________________
> Fast. Reliable. Get MSN 9 Dial-up - 3 months for the price of 1!
> (Limited-time Offer)
> http://click.atdmt.com/AVE/go/onm00200361ave/direct/01/
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 4: Don't 'kill -9' the postmaster
>
From | Date | Subject | |
---|---|---|---|
Next Message | Marc G. Fournier | 2004-03-03 15:21:28 | Re: [ANNOUNCE] PostgreSQL 7.3.6 Now Available ... |
Previous Message | Mike Mascari | 2004-03-03 15:19:01 | Re: making a copy of a table within the same database |