Postgres Pro
Downloads
Home   >   mailing lists

Re: about pg_proc (column pronamespace) - Mailing list pgsql-sql

From Tom Lane
Subject Re: about pg_proc (column pronamespace)
Date
Msg-id 23638.1252692770@sss.pgh.pa.us
Whole thread Raw
In response to about pg_proc (column pronamespace)  (Gerardo Herzig <gherzig@fmed.uba.ar>)
Responses Re: about pg_proc (column pronamespace)  (Gerardo Herzig <gherzig@fmed.uba.ar>)
List pgsql-sql
Tree view 
Gerardo Herzig <gherzig@fmed.uba.ar> writes:
> Obviously im missing something, i cant find any relation between
> pg_proc.pronamespace and pg_namespace.

You didn't look at pg_namespace.oid, which is a "system column"
meaning SELECT * doesn't show it.
        regards, tom lane

pgsql-sql by date:

Previous
From: Gerardo Herzig
Date:
Subject: about pg_proc (column pronamespace)
Next
From: Gerardo Herzig
Date:
Subject: Re: about pg_proc (column pronamespace)