Re: making a copy of a table within the same database - Mailing list pgsql-general

Karl O. Pinc wrote:

>
> On 2004.03.03 09:00 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?
>
>
> You might want to look at SELECT INTO ... .
>
> Karl <kop@meme.com>
> Free Software:  "You don't pay back, you pay forward."
>                  -- Robert A. Heinlein
>
> ---------------------------(end of broadcast)---------------------------
> TIP 4: Don't 'kill -9' the postmaster

See

http://www.postgresql.org/docs/7.4/static/sql-selectinto.html
http://www.postgresql.org/docs/7.4/static/sql-createtableas.html

for more info.

Nick