Modify postgresql default schema

How to change the default schema in Postgresql

When Postgresql database has multiple schema and Pentaho need explicit which schema is going to be used, you probably need modify your default schema by changing 'search_path' in postgresql.conf file (See details here). The postgresql.conf is normally under /var/lib/postgresql on Linux and /Library/PostgreSQL8/ on Mac (See references)

Alternatively, you can also use "ALTER USER user_name SET search_path to ...;" instead, after logging into the database.

References

• http://www.studiotips.net/docs/tips_sql/postgresql/installingpostgresqlonmac.html
• http://developer.apple.com/internet/opensource/postgres.html
• http://archives.postgresql.org/pgsql-admin/2003-07/msg00224.php
• http://archives.postgresql.org/pgsql-admin/2003-07/msg00222.php
• http://www.postgresql.org/docs/7.3/static/ddl-schemas.html
• http://www.mkyong.com/database/postgresql-how-to-change-default-schema/