[SOLVED] postgres public schema function aliasing


I am currently running postgres 8.4.4 and I have the need to override calls to functions that reside in the public schema of my database. For instance in pg_catalog there exists a function


I have a function placed within the public schema that overrides


My question comes down to overriding the call to public.upper(text). That is to say I have to execute the function call like so:

select public.upper(text);

Whereas I want to be able to call public.upper(text) in this manner:

select upper(text);

How does one go about doing this?


You can set schema search path and place pg_catalog at the end of your search path.
See 5.7.3. The Schema Search Path and 5.7.5. The System Catalog Schema in Postgres manual.

Answered By – jira

Answer Checked By – Mildred Charles (BugsFixing Admin)

Leave a Reply

Your email address will not be published. Required fields are marked *