var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
I want to run the SQL command across different database on the same host :
Is there any SQL syntax on PostgreSQL like above, that it can select the postgresql different database.
ps. I use PostgreSQL 7.1
Please help me!
Last edited by arm0001; 06-20-06 at 21:55.
With PostgreSQL, you can only open one database at a time. However, if you look under contributions on the PostgreSQL, there is a utility that allows multiple databases to be used. Hope that helps.
the utility is called dblink
"Lisa, in this house, we obey the laws of thermodynamics!" - Homer Simpson
"I have my standards. They may be low, but I have them!" - Bette Middler
"It's a book about a Spanish guy named Manual. You should read it." - Dilbert
XTreme VB Talk
Log in with your username and password
Forgot your password?
Subscribe to dBforums Brief to receive special offers from dBforums partners and sponsors