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