Re: current schema

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