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

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?

If you want a copy of the data and the fundamental table design, not
including constraints, triggers, indexes, foreign keys, etc.:

CREATE TABLE foo AS
SELECT * FROM bar;

...

Mike Mascari