How to get the size of non fixed-length field from system catalog ?

Поиск
Список
Период
Сортировка
От Postgres User
Тема How to get the size of non fixed-length field from system catalog ?
Дата
Msg-id b88c3460906081403q7634aca4x8e5998a679e1e422@mail.gmail.com
обсуждение исходный текст
Ответы Re: How to get the size of non fixed-length field from system catalog ?
Список pgsql-general
Hi,

I'm writing a small ORM tool and have written a number of queries to
retrieve table metadata.  One piece of data that I'm having trouble
hunting down is the size of a CHAR field.  For example, one table has
a 'user_id' column of type CHAR(36).  But when I look at the
pg_attribute and pg_type tables, I can't seem to find this size value
of 36.

Can anyone share the SQL that returns the size of a CHAR?  It is NOT
the 'typlen' column.  The answer may be the 'typelem' column, but I
can't find details on how to decode it.

Thanks.

В списке pgsql-general по дате отправления:

Предыдущее
От: Merlin Moncure
Дата:
Сообщение: Re: NOT NULL with CREATE TYPE
Следующее
От: Thomas Kellerer
Дата:
Сообщение: Re: How to get the size of non fixed-length field from system catalog ?