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
