Re: [pgadmin-support] How to access a table from one database to another database

2006-07-14 Thread Melvin Davidson
b directory of source code.   ie: postgresql-8.0.6/contrib/dblink   From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of VivekanandaSwamy R.Sent: Friday, July 14, 2006 7:31 AMTo: pgadmin-support@postgresql.orgSubject: [pgadmin-support] How to access a table from one database to anoth

[pgadmin-support] How to access a table from one database to another database

2006-07-14 Thread VivekanandaSwamy R.
Hai all, I have 2 databases namee PAO and CAS. PAO contains 3 schemas named Public,pao,sts CAS contains 4 schemas named Public,cao,sts,reports   Now  i am in PAO database..now i want access table 'activity' in schema 'cas' in CAS database. How it is posible.   2nd thing is...   i have 2