Re: [SQL] [JDBC] Calling a table in another database from plpgsql

2005-01-09 Thread Dave Cramer
Kris is correct, this is a jdbc list, however to satisfy your curiosity, you can't access data from another database. Dave [EMAIL PROTECTED] wrote: Hi, I have function called test1() in database 1. I need to input the value from this function into another table which is in database2. How can i ac

Re: [SQL] [JDBC] Calling a table in another database from plpgsql

2005-01-05 Thread Kris Jurka
On Wed, 5 Jan 2005, Dave Cramer wrote: > Kris is correct, this is a jdbc list, however to satisfy your curiosity, > you can't access data from another database. > You certainly can with dblink which is what his question was about. I didn't answer him because I remembered a recent off-topic q