Hi Michael, Thank you for the tip. The integration tool is OGSA-DAI. Of course, we have to specify the database but the connection string that it uses does not contain it.
Cheers, Samatha Michael Fuhr wrote: > On Thu, Jun 07, 2007 at 03:38:15PM +0200, Samatha Kottha wrote: > >> We are trying to access a postgres database using a data integration >> tool. This data integration tool have options to specify the hostname, >> port, userid, and passwd of a database. But there is no way to supply >> the database name. >> > > What data integration tool is it? Are you sure it doesn't have an > option to specify the database? > > >> So, I am thinking to set the database name to each user (default >> login database) so that they do not need to supply that info when >> they access data using data integration tool. >> > > In libpq applications a role's default database has the same name > as the role; you can override that with the PGDATABASE environment > variable. > > http://www.postgresql.org/docs/8.2/interactive/libpq-envars.html > > See also PGSERVICE, PGSYSCONFDIR, and the connection service file. > > http://www.postgresql.org/docs/8.2/interactive/libpq-pgservice.html > > -- Samatha Kottha Zentrum für Informationsdienste und Hochleistungsrechnen (ZIH) Technische Universität Dresden Tel: (+49) 351 463-38776 Room 1019 Fax: (+49) 351 463-38245 Noethnitzer Straße 46 01187 Dresden Germany ---------------------------(end of broadcast)--------------------------- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match
