detecting SQL system
От
John R Pierce
Тема
detecting SQL system
Дата
Msg-id
025a01c4a13e$8459f9f0$0200a8c0@hogranch.com
Список
Дерево обсуждения
Detecting SQL_ASCII databases Oliver Jowett <oliver@opencloud.com>
Re: Detecting SQL_ASCII databases Kris Jurka <books@ejurka.com>
Re: Detecting SQL_ASCII databases Oliver Jowett <oliver@opencloud.com>
Re: Detecting SQL_ASCII databases Kris Jurka <books@ejurka.com>
One of the Java developers in my group asked me today if there was any
reliable and portable way he could query JDBC to find out what database he
was connected to, Postgres vs Oracle vs TimesTen vs ???
So, I'm curious, are there any SQL standard methods of doing this? Is the
information_schema any part of the standard, i.e. could we
SELECT character_value FROM information.schema.sql_implementation_info
WHERE implementation_info_name = 'SERVER NAME';
?
Or do we have to poke around at each of these DBMS servers and figure out
whats unique about them ?
В списке pgsql-jdbc по дате отправления