Re: How to obtain the max length of a varchar(50) field.

Поиск
Список
Период
Сортировка
От Simon Riggs
Тема Re: How to obtain the max length of a varchar(50) field.
Дата
Msg-id BANLkTi=0pKw7vvjWwdQWv1LMaDhRsj9Jfg@mail.gmail.com
обсуждение исходный текст
Ответ на How to obtain the max length of a varchar(50) field.  (Mauro Ziliani <mauro@faresoftware.it>)
Ответы Re: How to obtain the max length of a varchar(50) field.  (Mauro Ziliani <mauro@faresoftware.it>)
Список pgsql-novice
On Thu, May 5, 2011 at 9:50 AM, Mauro Ziliani <mauro@faresoftware.it> wrote:
> Hi all.
> I'm working with Postgres 9.0 and wxWidgets.
> I need to query the db about a field of a table.
>
> The table T has a field varchar(50).
>
> table: TAB0
> customer: varchar(50)
>
> How can I get the max size of the field?
>
> The PQfsize function give me -1 because the field has dynamic size.
>
> Can you help me?

Try PQfmod()

--
 Simon Riggs                   http://www.2ndQuadrant.com/
 PostgreSQL Development, 24x7 Support, Training & Services

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

Предыдущее
От: ALT SHN
Дата:
Сообщение: Re: [GRASS-user] OCR
Следующее
От: Andreas Kretschmer
Дата:
Сообщение: Re: How to obtain the max length of a varchar(50) field.