Setting GPDB Parameters at the Database Level

posted Sep 13, 2012, 1:16 PM by Sachchida Ojha
When a session parameter is set at the database level, every session that connects to that database will pick up that parameter setting. Settings at the database level override those at the system level. Use the ALTER DATABASE command to set a parameter at the database level. For example:

=# ALTER DATABASE mydatabase SET search_path TO myschema;