postgres public schema function aliasing

Question

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

upper(text)

I have a function placed within the public schema that overrides

upper(text)

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?

I think it's a poor decision to name identically to native functions — OMG Ponies
– OMG Ponies, Commented Sep 16, 2010 at 18:19
I agree as well Ponies, its something I need to prove a potential issue with default user privileges. — Woot4Moo
– Woot4Moo, Commented Sep 16, 2010 at 18:22

jira · Accepted Answer · 2010-09-16 18:25:43Z

2

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 Sep 16, 2010 at 18:25

jira

3,9643 gold badges25 silver badges32 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

postgres public schema function aliasing

1 Answer 1

Comments

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Related