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.