From: Rudi Starcevic <rudi@oasis.net.au>
To: Ligia Pimentel <lmpimentel@yahoo.com>
Cc: pgsql-sql@postgresql.org
Subject: Re: Selecting data from a table created in another database...
Date: Thu, 04 Jul 2002 11:47:58 +1000
Message-ID: <3D23A94E.3050208@oasis.net.au> (raw)
References: <aft59r$24k1$1@news.hub.org>
Hi Ligia,
When I need to do this I use a scripting language like PHP, Perl or
ColdFusion to
select from one db and insert into another.
As a matter of fact I had to do this exercise just yesturday.
I like it as I find I have much more freedom to gather data, organise it
then insert it.
It's easy to view the output of your selects on the screen and when
happy do the insert(s).
Hope this helps.
Regards
Rudi Starcevic.
Ligia Pimentel wrote:
>I don't know if this can be done...
>
>In MSSQL Server I can access a table created in another database (on the
>same server, of course) by using the following syntaxis...
>
>select * from databasename..tablename where condition;
>
>Can I do this in postgres?
>
>I'm using version 7.2 on a redhat server...
>
>Thank you for your help...
>
>Ligia
>
>
>
>
>
>
>
>
>---------------------------(end of broadcast)---------------------------
>TIP 6: Have you searched our list archives?
>
>http://archives.postgresql.org
>
>
>
>
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: rudi@oasis.net.au, lmpimentel@yahoo.com
Subject: Re: Selecting data from a table created in another database...
In-Reply-To: <3D23A94E.3050208@oasis.net.au>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
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