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

2006-08-31 Thread Melvin Davidson
table from one database to another database 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

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

2006-08-30 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

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

2006-07-05 Thread Tomi NA
On 7/4/06, Sim Zacks <[EMAIL PROTECTED]> wrote: I can think of numerous examples where someone might want to run a query against databases on different databases or servers. I don't think it has anything to do with design. Couldn't agree more. t.n.a. ---(end of broadca

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

2006-07-04 Thread Antoine
As an aside, Vivekananda, your questions (all of the recent ones) belong on the pgsql maillist and not on the pgadmin maillist and you shouldn't be emailing the pgadmin owner as well. And he probably shouldn't be posting html either! ;-) Antoine -- This is where I should put some witty comment

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

2006-07-04 Thread Sim Zacks
aSwamy R. To: pgadmin-support@postgresql.org ; [EMAIL PROTECTED] Sent: Tuesday, July 04, 2006 12:34 AM Subject: [pgadmin-support] How to access table from one database to another database hi, I have 2 databases namee PAO and CAS. PAO contains 3 schemas named Public,pao,sts CAS con

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

2006-07-04 Thread Derrick Betts
the structure of your DB system.   Hope this helps, Derrick - Original Message - From: VivekanandaSwamy R. To: pgadmin-support@postgresql.org ; [EMAIL PROTECTED] Sent: Tuesday, July 04, 2006 12:34 AM Subject: [pgadmin-support] How to access table from one

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

2006-07-03 Thread VivekanandaSwamy R.
  hi, 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 serv