Re: Array Char/VarChar Size

Поиск
Список
Период
Сортировка
От Kris Jurka
Тема Re: Array Char/VarChar Size
Дата
Msg-id Pine.BSO.4.64.0802291248520.30295@leary.csoft.net
обсуждение исходный текст
Ответ на Re: Array Char/VarChar Size  (dmp <danap@ttc-cmc.net>)
Ответы Re: Array Char/VarChar Size  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-jdbc

On Fri, 29 Feb 2008, dmp wrote:

> Perhaps this is not the appropriate list, but is there a way to
> determine this information from the information_schema? The reason I ask
> is I can not seem to find this information there either. pg_dump does
> provide this information, though lacking the ability to proper identify
> multi-dimensional arrays, ex. char(30)[][] gives char(30)[].

Multi-dimensional array information is not stored.  Every array type may
be any number of dimensions.  The precision information is not available
in the information_schema, but it is available in the system catalog
tables.  See pg_attribute.atttypmod, but it does require some decoding.

Kris Jurka


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

Предыдущее
От: dmp
Дата:
Сообщение: Re: Array Char/VarChar Size
Следующее
От: Kris Jurka
Дата:
Сообщение: Re: Bug while retrieving money data type from db