I have to select database through my installing process. Because I built a software that will work with any database. But I have a problem on how to identify database dynamicaly that means while software is on installing process. Are there any isue in postgresql such as giving some sql query..
You don't specify either your target machine O/S, or your programming language.
In the windows environment, it may be simplest to display the OleDB Datalink editor. Your user could select their database(s) for you.
ref the second post here for a sample chunk of VB code to open the datalink editor.
Once you're connected, you can query the postgres information schema (look it up in the documentation) to get detailed info re the database structure
Last edited by loquin; 05-14-07 at 15:55.
"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