Postgres Pro
Downloads
Home   >   mailing lists

copy table - Mailing list pgsql-sql

From Shavonne Marietta Wijesinghe
Subject copy table
Date
Msg-id 004801c5d09b$747fad80$1102a8c0@dream
Whole thread Raw
Responses Re: copy table
Re: copy table
List pgsql-sql
Tree view
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

pgsql-sql by date:

Previous
From: "A. Kretschmer"
Date:
Subject: Re: copy tables
Next
From: David Pradier
Date:
Subject: Design problemi : using the same primary keys for inherited objects.