Re: [GENERAL] Select from multiple db's

1999-07-14 Thread Peter Eisentraut
On Wed, 14 Jul 1999, Aaron Holtz wrote: > Is it possible with postgres to do a select from tables contained in > separate databases? I have two separate db's that are maintained, but > would like to make a select from one of them to insert the data into the > second one. Any thoughts on how to

[GENERAL] Select from multiple db's

1999-07-14 Thread Aaron Holtz
Is it possible with postgres to do a select from tables contained in separate databases? I have two separate db's that are maintained, but would like to make a select from one of them to insert the data into the second one. Any thoughts on how to make this work would be appreciated. Merging the