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

From: "Karl O(dot) Pinc" <kop(at)meme(dot)com>
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:22:59
Message-ID: 20040303092259.C12220@mofo.meme.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general


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(at)meme(dot)com>
Free Software: "You don't pay back, you pay forward."
-- Robert A. Heinlein

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Nick Barr 2004-03-03 15:25:14 Re: making a copy of a table within the same database
Previous Message Marc G. Fournier 2004-03-03 15:21:28 Re: [ANNOUNCE] PostgreSQL 7.3.6 Now Available ...