Re: making a copy of a table within the same database

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
>