| From: | Kenneth Gonsalves <lawgon(at)thenilgiris(dot)com> |
|---|---|
| To: | pgsql-sql(at)postgresql(dot)org |
| Subject: | Re: How do I copy part of table from db1 to db2 (and rename the columns)? |
| Date: | 2005-08-31 10:15:49 |
| Message-ID: | 200508311545.49846.lawgon@thenilgiris.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general pgsql-sql |
On Wednesday 31 Aug 2005 3:30 pm, Joost Kraaijeveld wrote:
> Hi,
>
> I want to copy several columns of a source table from db1 to db2,
> and create the target table and rename the columns in the process.
>
> Is that possible in PostgresQL? If so, an example or url for such a
> command /script would be appreciated...
checkout dblink
--
regards
kg
http://www.livejournal.com/users/lawgon
tally ho! http://avsap.org.in
ಇಂಡ್ಲಿನಕ್ಸ வாழ்க!
| From | Date | Subject | |
|---|---|---|---|
| Next Message | David Sankel | 2005-08-31 10:30:14 | Removing all users from a group |
| Previous Message | Joost Kraaijeveld | 2005-08-31 10:00:30 | How do I copy part of table from db1 to db2 (and rename the columns)? |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Roman Neuhauser | 2005-08-31 10:40:11 | Re: How do I copy part of table from db1 to db2 (and rename the columns)? |
| Previous Message | Joost Kraaijeveld | 2005-08-31 10:00:30 | How do I copy part of table from db1 to db2 (and rename the columns)? |