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/


---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster

Hello

select into is usefull cmd for you

http://developer.postgresql.org/docs...electinto.html

select * into newtable from oldtable;

regards
Pavel Stehule


On Wed, 3 Mar 2004, Sally Sally wrote:


---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?

http://www.postgresql.org/docs/faqs/FAQ.html

Sally Sally wrote:

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


---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster

create table newtable as select * from oldtable;


Sally Sally wrote:


---------------------------(end of broadcast)---------------------------
TIP 8: explain analyze is your friend

On 2004.03.03 09:00 Sally Sally wrote:
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

---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster

Karl O. Pinc wrote:

See

http://www.postgresql.org/docs/7.4/s...electinto.html
http://www.postgresql.org/docs/7.4/s...tetableas.html

for more info.

Nick



---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster

On Wed, 2004-03-03 at 15:00, Sally Sally wrote:
There are several ways to do it, depending on what you want.

You can create a new table (with no constraints):

SELECT * INTO new_table FROM old_table;

Or create the new table with any necessary constraints, then:

INSERT INTO new_table SELECT * FROM old_table;

Or dump to text and edit the dump file to change all occurrences of the
table name:

pg_dump -d my_database -t old_table > dump.sql
vi dump.sql
psql -d my_database < dump.sql

or edit on the fly (if the old table name doesn't occur except as a
table name):

pg_dump -d my_database -t old_table |
sed -e 's/old_table/new_table/g' |
psql -d my_database
--
Oliver Elphick <olly (AT) lfix (DOT) co.uk>
LFIX Ltd


---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to majordomo (AT) postgresql (DOT) org)