Re: Quick System Catalog Query Question

Terry Hampton <thampton@limacorp.com> writes:

>     Manuel,
>
> Many thanks for your quick reply.  When I
> enter:      SELECT * FROM pg_type where typname='varchar';
>
>        I get:
>
> typname | typowner | typlen | typprtlen | typbyval | typtype | typisdefined
> | typdelim | typrelid | typelem | typinput  | typoutput  | typreceive |
> typsend   | typalign | typstorage | typdefault
>
>
---------+----------+--------+-----------+----------+---------+--------------+----------+----------+---------+-----------+------------+------------+------------+----------+------------+------------
>   varchar |        1 |     -1 |        -1 | f        | b       | t      | ,
> |        0 |       0 | varcharin | varcharout | varcharin  | varcharout | i
> | x          |
>
>
>
> I do not see "1043",  thus my original email.

OID, among others is a hidden column, you need to explicitly ask for
it in your query:

SELECT oid, * FROM pg_type WHERE typname='varchar';

>
> I'm just now starting to work with OID's.    Does every row
> in the system catalogs have an OID?

Most of them.

> reference to another tablename.oid - to get the actual name, simply
> use the known OID from the first table as a lookup value into the
> second ( reference table ), to get the textual vlaue.  ?  Correct ?

Correct.

Regards,
Manuel.