Set default search path in pgAdmin

Question

Every time I open pgAdmin I have to do this:

set search_path="schema";

Is there a way to set a default search path value?

Read here: [Postgresql Schema Path permanently](http://stackoverflow.com/questions/2875610/postgresql-schema-path-permanently/2875687) — informatik01, Apr 25 '13 at 15:08

score 7 · Accepted Answer · answered Sep 07 '13 at 01:54

7

yes, you can modify the user:

alter role «user_name» set search_path = '«schema_name»';

answered Sep 07 '13 at 01:54

maletin

198
1
6

2

Note that the single quotes around the schema_name are optional, unless maybe you have some non alphanumeric characters in it. And of course you can set search_path to a comma separated list of schema names. – laurent Aug 04 '17 at 12:32

score 1 · Answer 2 · answered Sep 15 '21 at 02:02

1

To set the value DB-wide you can also set a parameter for search_path in the database properties pane (confirmed in pgAdmin 5.7).

answered Sep 15 '21 at 02:02

mwil.me

111
2

This setting will be stored on the database server and will affect other clients. – basin Oct 28 '21 at 15:59

score 1 · Answer 3 · answered Apr 21 '15 at 12:28

You can also use macro feature of pgAdmin III to simplify task.

Although first answer is correct you can accidentally overwrite user related configuration the app can rely on. If application is not well written or is very complex and you have to use the same user, it is better to use feature of pgAdmin.

I haven't found better working solution in pgAdmin III 1.20 than assigning a macro to keyboard shortcut with instruction to alter search path - it's a regular SET search_path=first_schema, second_schema I assume the best solution will be to set search_path property of DB instance for pgAdmin connection, but despite presence of Properties.../Variables tab in instance context menu it looks disabled.

Set default search path in pgAdmin

3 Answers3