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 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 > >
---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster
