copy table

From: "Shavonne Marietta Wijesinghe" <shavonne(dot)marietta(at)studioform(dot)it>
To: <pgsql-sql(at)postgresql(dot)org>
Subject: copy table
Date: 2005-10-14 08:44:13
Message-ID: 004801c5d09b$747fad80$1102a8c0@dream
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

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

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message David Pradier 2005-10-14 09:18:30 Design problemi : using the same primary keys for inherited objects.
Previous Message A. Kretschmer 2005-10-14 07:25:43 Re: copy tables