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
 

Reply via email to