look at pg_dump. If you want to do this in real-time please specify ?
Jim ----- Original Message ----- From: "[EMAIL PROTECTED]" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> 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 > ---------------------------(end of broadcast)--------------------------- TIP 7: don't forget to increase your free space map settings