Postgres Pro
Downloads
Home   >   mailing lists

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

From Sally Sally
Subject making a copy of a table within the same database
Date
Msg-id BAY9-F9qCTUrtbk5AuJ0003ccbf@hotmail.com
Whole thread Raw
Responses Re: making a copy of a table within the same database
Re: making a copy of a table within the same database
Re: making a copy of a table within the same database
Re: making a copy of a table within the same database
Re: making a copy of a table within the same database
List pgsql-general
Tree view 
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/

pgsql-general by date:

Previous
From: Hervé Piedvache
Date:
Subject: How index are running and how to optimise ?
Next
From: Tom Lane
Date:
Subject: Re: Selecting reals into doubles