From: | Muralidharan Ramakrishnan <contact2muraliin(at)yahoo(dot)co(dot)in> |
---|---|
To: | Shavonne Marietta Wijesinghe <shavonne(dot)marietta(at)studioform(dot)it>, pgsql-sql(at)postgresql(dot)org |
Subject: | Re: copy table |
Date: | 2005-10-14 14:48:05 |
Message-ID: | 20051014144805.57201.qmail@web8609.mail.in.yahoo.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-sql |
INSERT INTO MYSCHEMA2.TABLENAME
SELECT * FROM MYSCHEMA1.TABLENAME WHERE < CONDITION >
Shavonne Marietta Wijesinghe <shavonne(dot)marietta(at)studioform(dot)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 | Date | Subject | |
---|---|---|---|
Next Message | Daryl Richter | 2005-10-14 14:57:26 | Re: Design problem : using the same primary keys for inherited |
Previous Message | Andreas Kretschmer | 2005-10-14 13:18:19 | Re: sql function |