Re: Copy between Databases

look at pg_dump.

If you want to do this in real-time please specify ?

Jim
----- Original Message -----
From: "derrick(at)grifflink(dot)com" <Derrick(at)grifflink(dot)com>
To: <pgadmin-support(at)postgresql(dot)org>
Sent: Wednesday, May 26, 2004 11:58 AM
Subject: [pgadmin-support] Copy between Databases

> Is there a way to copy tables, functions, etc. between databases and
servers
> within pgAdmin?
>
> For example, within pgAdmin we have:
> Server1 has a database called DB1 with a table called Table1.
> Server2 has a database called DB2 with a table called Table2.
>
> I want to copy the data and metadata from Table1 to Table2. Is this
> possible? If so, how?
>
> Thanks,
> Derrick
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 8: explain analyze is your friend
>