Hi, all
I tried to use "set search_path to x1, x2, public" for postgreSQL when doing a connection. After that, I won't specify schema for any database object in sql, or plpgsql for postgreSQL will search it by the order I set at the connection. While with pgAdmin, I can't find such a connection settings which I can do "set seach_path". If I open an sql window to do it, the pgAdmin didn't get the search path. It seems every sql window has its own connection. Is that possible to let sql window use the same connection with the pgAdmin? Thank you jin advance!
Jack