From: Ligia Pimentel <pimentel_ligia@hotmail.com>
To: pgsql-sql@postgresql.org
Subject: Re: Selecting data from a table created in another database...
Date: Thu, 4 Jul 2002 08:49:31 -0500
Message-ID: <ag1ngu$2qjd$1@news.hub.org> (raw)
References: <3D23A94E.3050208@oasis.net.au>
Thanks.
"Rudi Starcevic" <rudi@oasis.net.au> wrote in message
news:3D23A94E.3050208@oasis.net.au...
> 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
> >
> >
> >
> >
>
>
>
>
>
>
> ---------------------------(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: pimentel_ligia@hotmail.com
Subject: Re: Selecting data from a table created in another database...
In-Reply-To: <ag1ngu$2qjd$1@news.hub.org>
* 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