--- Richard Huxton <dev@archonet.com> wrote: > Matthew Peter wrote: > > I have DB1 and DB2 pg_databases... I then have a function in DB2 that > > wants some results from DB1, is it possible to query another db? Like > > how \! lets you hit the command line... but I need it in plpgsql if > > possible. > > Look into the db_link or dbi_link packages. These are exactly what you > are after. > > -- > Richard Huxton > Archonet Ltd >
Perfect. Leave it to me not to check the contrib package first :) Thanks again ____________________________________________________________________________________ Cheap talk? Check out Yahoo! Messenger's low PC-to-Phone call rates. http://voice.yahoo.com ---------------------------(end of broadcast)--------------------------- TIP 5: don't forget to increase your free space map settings
