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 "
am 14.10.2005, um 10:44:13 +0200 mailte Shavonne Marietta Wijesinghe folgendes:
> Hello
>
> How can i copy a table from one schema to another..
create table as select * from table
>
> Example..
Yeah!
test=# create schema foo;
CREATE SCHEMA
test=# create schema bar;
CREATE SCHEMA
test=# creat
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
