pg.ddx.io pgsql-sql@postgresql.org mailing list archive
help / color / mirror / Atom feedpgsql multi-database queries
2+ messages / 2 participants
[nested] [flat]
* pgsql multi-database queries
@ 2004-04-08 07:52 yek ching <ynching@hotmail.com>
0 siblings, 1 reply; 2+ messages in thread
From: yek ching @ 2004-04-08 07:52 UTC (permalink / raw)
To: pgsql-sql
Dear Sir/Miss,
Is there a way to do a multi-database select query??.. I fail to find the
related solution... currently i i created seperate table call stockmaster
under seperate database for each seperate organizations... When i want to
queries out the stock item qty for multi database, i face a problem where
sql only can work for single database..
How can i use the same SQL statement in Pgsql??..
"SELECT * FROM A.stockmaster,B.stockmaster where A.item=B.item"
Regards,
Ching
_________________________________________________________________
Are you in love? Find a date on MSN Personals http://match.msn.com.my/
^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: pgsql multi-database queries
@ 2004-04-10 01:23 scott.marlowe <scott.marlowe@ihs.com>
parent: yek ching <ynching@hotmail.com>
0 siblings, 0 replies; 2+ messages in thread
From: scott.marlowe @ 2004-04-10 01:23 UTC (permalink / raw)
To: yek ching <ynching@hotmail.com>; +Cc: pgsql-sql
On Thu, 8 Apr 2004, yek ching wrote:
> Dear Sir/Miss,
>
> Is there a way to do a multi-database select query??.. I fail to find the
> related solution... currently i i created seperate table call stockmaster
> under seperate database for each seperate organizations... When i want to
> queries out the stock item qty for multi database, i face a problem where
> sql only can work for single database..
>
> How can i use the same SQL statement in Pgsql??..
> "SELECT * FROM A.stockmaster,B.stockmaster where A.item=B.item"
Look in the contrib/dblink directory in the source tar ball.
^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2004-04-10 01:23 UTC | newest]
Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2004-04-08 07:52 pgsql multi-database queries yek ching <ynching@hotmail.com>
2004-04-10 01:23 ` scott.marlowe <scott.marlowe@ihs.com>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox