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.