|
On running the below command in bash throws:
Command line: Why is it searching relation rather than schema? How can I set default schema to be searched, and can I set a list of multiple schemas from multiple databases as default list? |
||||
|
|
The reason it's not finding it, is most probably because you created the schema and the table using doublequotes: which makes the names case sensitive and forces you to always use quotes to qualify the name. Please see the manual for details about "delimited identifiers" (aka "quoted identifiers): http://www.postgresql.org/docs/9.2/static/sql-syntax-lexical.html#SQL-SYNTAX-IDENTIFIERS
See the "set schema" statement: http://www.postgresql.org/docs/current/static/sql-set.html You can also define a default schema using the
Yes, set the search_path configuration variable: http://www.postgresql.org/docs/current/static/runtime-config-client.html#GUC-SEARCH-PATH This can also be set permanently through an |
|||||
|
