Re: Selecting data from a table created in another database...

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