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

[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