Mailbox-Line: From pimentel_ligia@hotmail.com  Thu Jul  4 10:59:12 2002
From: "Ligia Pimentel" <pimentel_ligia@hotmail.com>
Subject: Re: Selecting data from a table created in another database...
Date: Thu, 4 Jul 2002 08:49:31 -0500
Organization: .
Lines: 64
Message-ID: <ag1ngu$2qjd$1@news.hub.org>
References: <3D23A94E.3050208@oasis.net.au>
Reply-To: "Ligia Pimentel" <pimentel_ligia@hotmail.com>
To: pgsql-sql@postgresql.org

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