>Now i am in PAO database..now i want
access table 'activity' in schema 'cas' in CAS
database.
>How it is
posible.
>i have 2 servers access i.e local and
mainserver.
>How access table from one server to another
server?
Please note, these are not question that are specific
to Pgadmin.
You should be asking these question
of [EMAIL PROTECTED]g
The short
answer is that Postgresql currently does not support inter database /
server
connectivity.
However, you can accomplish what you need by using the dblink
utility
provided in
the contrib 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 AM
To: pgadmin-support@postgresql.org
Subject: [pgadmin-support] 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 database..now i want access table 'activity' in schema 'cas'
in CAS database.
How it is
posible.
2nd thing
is...
i have 2
servers access i.e local and mainserver.
How
access table from one server to another server?
please tel
me...because we need this one
Thanks and
regards
Vivekananda.R | Software Engineer | CGDA Program.
Information transmitted by this
e-mail is proprietary to Infinite Computer Solutions and / or its
Customers and is intended for use only by the individual or the entity to
which it is addressed, and may contain information that is privileged,
confidential or exempt from disclosure under applicable law. If you are
not the intended recipient or it appears that this mail has been forwarded
to you without proper authority, you are notified that any use or
dissemination of this information in any manner is strictly prohibited. In
such cases, please notify us immediately at [EMAIL PROTECTED] and delete
this email from your records. |