CODEWITHSUNDEEP
sqlreflectiondatabasemonetdb
einpoklum
einpoklum

Reputation: 131636

In MonetDB, can I obtain the database name via SQL commands?

Does MonetDB make the current DB name (i.e. not the DBMS hostname, but the DB, or set of tables, that you connect to) available via SQL queries to some of the system table?

Upvotes: 2

Views: 220

Answers (1)

Hannes Mühleisen
Hannes Mühleisen

Reputation: 2562

Yes, the env() table-producing function also has the db name, in my case 'acs'.

sql>select value from env() where name='gdk_dbname';
+-------+
| value |
+=======+
| acs   |
+-------+

Upvotes: 3

Related Questions