| 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: | Whole Thread | Raw Message | 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 |