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

-- Niels Nes, Manager ITF, Centrum Wiskunde & Informatica (CWI) Science Park 123, 1098 XG Amsterdam, The Netherlands room L3.14, phone ++31 20 592-4098 sip:4098@sip.cwi.nl url: https://www.cwi.nl/people/niels e-mail: Niels.Nes@cwi.nl