Permanently Set Postgresql Schema Path

by

(And if you have no admin access to the server)

ALTER ROLE <your_login_role> SET search_path TO a,b,c;

Two important things to know about:

  1. When a schema name is not simple, it needs to be wrapped in double quotes.
  2. The order in which you set default schemas a, b, c matters, as it is also the order in which the schemas will be looked up for tables. So if you have the same table name in more than one schema among the defaults, there will be no ambiguity, the server will always use the table from the first schema you specified for your search_path.

More Related Contents:

  1. How to return result of a SELECT inside a function in PostgreSQL?
  2. Possible to perform cross-database queries with PostgreSQL?
  3. Reset auto increment counter in postgres
  4. Optimize query with OFFSET on large table
  5. GROUP BY and aggregate sequential numeric values
  6. Safely rename tables using serial primary key columns
  7. How to use (install) dblink in PostgreSQL?
  8. get JOIN table as array of results with PostgreSQL/NodeJS
  9. updating table rows in postgres using subquery
  10. How can I send email from PostgreSQL trigger?
  11. Find overlapping date ranges in PostgreSQL
  12. How do you do date math that ignores the year?
  13. Postgres manually alter sequence
  14. PostgreSQL: encoding problems on Windows when using psql command line utility
  15. Get the distinct sum of a joined table column
  16. How much disk-space is needed to store a NULL value using postgresql DB?
  17. Aggregate a single column in query with many columns
  18. Aggregating (x,y) coordinate point clouds in PostgreSQL
  19. PostgreSQL convert columns to rows? Transpose?
  20. Does Postgres support nested or autonomous transactions?
  21. PostgreSQL delete with inner join
  22. Regular expression in PostgreSQL LIKE clause
  23. Why is iterating through a large Django QuerySet consuming massive amounts of memory?
  24. Update a column of a table with a column of another table in PostgreSQL
  25. Check if NULL exists in Postgres array
  26. Generate DEFAULT values in a CTE UPSERT using PostgreSQL 9.3
  27. How to detect query which holds the lock in Postgres?
  28. PostgreSQL how to create a copy of a database or schema?
  29. PostgreSQL: fill NULL values in timeserie query with previous value
  30. Get most common value for each value of another column in SQL

Leave a Comment