Re: [SQL] copy table

[Muralidharan Ramakrishnan]

INSERT INTO MYSCHEMA2.TABLENAME

     SELECT * FROM MYSCHEMA1.TABLENAME WHERE < CONDITION >

Shavonne Marietta Wijesinghe <[EMAIL PROTECTED]> 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.