Getting list of supported types in Postgres

Поиск
Список
Период
Сортировка
От Ivan Radovanovic
Тема Getting list of supported types in Postgres
Дата
Msg-id 520B7556.4020702@gmail.com
обсуждение исходный текст
Ответы Re: Getting list of supported types in Postgres  (Bruce Momjian <bruce@momjian.us>)
Re: Getting list of supported types in Postgres  (John R Pierce <pierce@hogranch.com>)
Список pgsql-general
Hi guys,

I am looking for a way to get list of supported types in Postgres
together with information whether type can have optional size (like
varchar for example), whether it can have precision (like decimal for
example), and whether it can come as value of sequence (like all integer
types for example), but I have trouble getting that info from pg_type
table. This is SQL I was using:

select
    pg_catalog.format_type(oid, null),
    *
from
    pg_type
where
    typnamespace = (select oid from pg_namespace where
nspname='pg_catalog') and
    typisdefined and
    typname not like '$_%' escape '$' and
    typname not like 'pg%' and
    typtype = 'b'
order by
    typname

apparently pg_catalog.format_type for some types return quoted name
("char" for example), also I can't find decimal in results (there is
numeric, but I would like to have complete list of supported types, so
decimal should be included too). In documentation it is said that typlen
of -1 or -2 means that type is variable length, but I don't know how to
find out if type can have additional precision?

Regards,
Ivan


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

Предыдущее
От: Albe Laurenz
Дата:
Сообщение: Re: please suggest i need to test my upgrade
Следующее
От: bweishoff@charter.net
Дата:
Сообщение: Postgres timeouts?