hi Ligia,
there was a posting to this list some time ago, about the same question.
I just found it as I had the same question as you:
http://archives.postgresql.org/pgsql-sql/1998-05/msg00091.php
(in short: it is not possible in Postgres)
the mail is from 1998, but I just tried to make a sele
Thanks.
"Rudi Starcevic" <[EMAIL PROTECTED]> wrote in message
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
> 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 exerci
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 eas
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'
