Top "Search-path" questions

How to check if a table exists in a given schema

Postgres 8.4 and greater databases contain common tables in public schema and company specific tables in company schema. company schema names …

sql database postgresql information-schema search-path
Xcode 5 Framework/Library Search Path Absolute Address

I updated my Xcode to 5.0. I added some library/framework search paths and the path it's displaying is the absolute …

ios xcode frameworks xcode5 search-path
no schema has been selected to create in ... error

I am working on a linux server that is hosted on amazons server and I have completely setup the server …

python linux postgresql ubuntu search-path
How does the search_path influence identifier resolution and the "current schema"

Is it possible to define in which schema new tables get created by default? (Referred by "unqualified table names".) I've …

postgresql schema database-table search-path
makefile : How to link object files from different subdirectory and include different search paths

I want to change the location of my test code (tsnnls_test_DKU.c) and I am unable to make …

c++ c makefile search-path
SQL state: 42883, No function matches the given name and argument types. But that function actually exists

I have a server with PostgreSQL 8.1.23, with a function that works perfectly when it runs with postgres user, but with …

postgresql function casting search-path
Unable to use crosstab in Postgres

Postgres 9.2.1 on OSX 10.9.2. If I run the following crosstab example query: CREATE EXTENSION tablefunc; CREATE TABLE ct(id SERIAL, rowid …

postgresql crosstab search-path
PostgreSQL search_path change not working as advertised

I am using PostgreSQL 9.0.3 on RedHat. The database contains two schemas, public and wh. I created a new role called …

postgresql privileges search-path
How to set default schema in Yii2

My Yii2 is setup with PostgreSQL. Instead of using separate database per project, I like to use schema for each …

postgresql migration database-schema yii2 search-path
controlling which project header file Xcode will include

My Xcode project builds to variations of the same product using two targets. The difference between the two is only …

xcode include search-path