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
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
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
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
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
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
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