How to connect or set a specifig schema in LIBGDA database browser?

Question

I've here a PostgreSQL based database, with a schema and some tables inside it. When I use psql I must put the schema name in front of every statement:

SELECT * FROM schemahere.tablehere;

Or is set the search path like this:

SET search_path = webmka;

That works both. But within the database-browser of LIBGDA I can't see the schema itself (why?) and I can't fire the SET command. Can I use the connection options?

Answer 1

If LIBGDA doesn't understand schemas, you can work around this with one of the following:

• ALTER DATABASE the_database SET search_path = webmka, public;
• ALTER USER libgda_user SET search_path = webmka, public;

to make the search_path persistently associated with either the database of interest (1st option) or a user dedicated to libgda (2nd option).