Home > mailing lists

Re: copy table - Mailing list pgsql-sql

From	Muralidharan Ramakrishnan
Subject	Re: copy table
Date	October 14, 2005 14:48:11
Msg-id	20051014144805.57201.qmail@web8609.mail.in.yahoo.com Whole thread Raw
In response to	copy table ("Shavonne Marietta Wijesinghe" <shavonne.marietta@studioform.it>)
List	pgsql-sql

INSERT INTO MYSCHEMA2.TABLENAME

SELECT * FROM MYSCHEMA1.TABLENAME WHERE < CONDITION >

Shavonne Marietta Wijesinghe <shavonne.marietta@studioform.it> wrote:

Hello

How can i copy a table from one schema to another..

Example..

* I have a database "mydatabase"

* then i have 2 schemas "myschema1" and "myschema2"

* in "myschema1" i have inserted a new line and i want to copy that to "myschema2" so they both will be same..

How can i do it with SQL ??

I use pgadmin 3 to make my database in postgresql

thank u

Yahoo! India Matrimony: Find your partner now.

From: Andreas Kretschmer
Date: 14 October 2005, 13:14:11
Subject: Re: sql function

From: Daryl Richter
Date: 14 October 2005, 14:55:44
Subject: Re: Design problem : using the same primary keys for inherited