Re: Quick System Catalog Query Question - Mailing list pgsql-admin

From Manuel Sugawara
Subject Re: Quick System Catalog Query Question
Date
Msg-id m3hdw79ubs.fsf@conexa.fciencias.unam.mx
Whole thread Raw
In response to Quick System Catalog Query Question  (Terry Hampton <thampton@limacorp.com>)
List pgsql-admin
Terry Hampton <thampton@limacorp.com> writes:

> I can't determine what SQL to which system catalog will associate
> "1043" to "varchar" and "25" to "text"

pg_type where oid = 1043, ie:

SELECT * FROM pg_type WHERE oid = 1043;

Regards,
Manuel.

pgsql-admin by date:

Previous
From: "Richard Harris"
Date:
Subject: Database consistency checker
Next
From: Tom Lane
Date:
Subject: Re: Database consistency checker