Thanks.
"Rudi Starcevic" <rudi(at)oasis(dot)net(dot)au> wrote in message
news:3D23A94E(dot)3050208(at)oasis(dot)net(dot)au(dot)(dot)(dot)
> 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
>
>