making a copy of a table within the same database

From: "Sally Sally" <dedeb17(at)hotmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: making a copy of a table within the same database
Date: 2004-03-03 15:00:14
Message-ID: BAY9-F9qCTUrtbk5AuJ0003ccbf@hotmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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/

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2004-03-03 15:04:29 Re: Selecting reals into doubles
Previous Message Hervé Piedvache 2004-03-03 14:48:44 How index are running and how to optimise ?