Thanks to Jennie I understand that I can get the current schema with the query:
select current_schema from sys.var();
While I get the “right” response, I get it as a series of duplicated lines (10 at the last count):
For example, after setting a schema as
set schema viewer;
I get the following 10 lines from the query:
Is it the right behaviour?
And if yes, do these lines have a specific significance?
Thanks
Enzo enzo@smartinsightsfromdata.com
On Sun, Oct 18, 2015 at 09:48:06PM +0100, Enzo wrote:
Thanks to Jennie I understand that I can get the current schema with the query:
select current_schema from sys.var();
While I get the “right” response, I get it as a series of duplicated lines (10 at the last count):
For example, after setting a schema as
set schema viewer;
I get the following 10 lines from the query:
Is it the right behaviour?
select current_schema; is what you need. Try select * from sys.var(), it will give you a list of variables. Each can be queried using a simple select variable_name;
Niels
And if yes, do these lines have a specific significance?
Thanks
Enzo enzo@smartinsightsfromdata.com
users-list mailing list users-list@monetdb.org https://www.monetdb.org/mailman/listinfo/users-list
participants (2)
-
Enzo
-
Niels Nes