Re: [GENERAL] How to access a table from one database to another database

2006-07-14 Thread A. Kretschmer
am 15.07.2006, um 10:26:55 +0530 mailte VivekanandaSwamy R. folgendes: > Now i am in PAO database..now i want access table 'activity' in schema > 'cas' in CAS database. > How it is posible. > ... > How access table from one server to another server? 08:02 < akretschmer> ??dblink 08:02 < rtfm_ple

Re: [GENERAL] How to access a table from one database to another database

2006-07-14 Thread Gregory S. Williamson
: pgsql-general@postgresql.org Cc: Subject:[GENERAL] How to access a 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

Re: [GENERAL] How to access a table from one database to another

2006-07-14 Thread Tony Caduto
VivekanandaSwamy R. wrote: 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 t

Re: [GENERAL] How to access a table from one database to another

2006-07-14 Thread John Purser
On Sat, 15 Jul 2006 10:26:55 +0530 "VivekanandaSwamy R." <[EMAIL PROTECTED]> wrote: > > > 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

[GENERAL] 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