Re: How to obtain the max length of a varchar(50) field.
От
Mauro Ziliani
Тема
Re: How to obtain the max length of a varchar(50) field.
Дата
Msg-id
4DC277AB.6090206@faresoftware.it
Ответ на
Re: How to obtain the max length of a varchar(50) field. (Andreas Kretschmer)
Список
Дерево обсуждения
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. Andreas Kretschmer <akretschmer@spamfence.net>
Re: 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. Simon Riggs <simon@2ndQuadrant.com>
Re: How to obtain the max length of a varchar(50) field. Mauro Ziliani <mauro@faresoftware.it>
On 05/05/2011 11:03, Andreas Kretschmer wrote: > Mauro Ziliani 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? > select max(length(customer)) from tab0; > > > > Andreas Thank you for the suggestion. But I look a C function which access PGresult record. This is usefull for an sql script. Thank you very much. MZ
В списке pgsql-novice по дате отправления
От: Mauro Ziliani
Дата:
От: Grzegorz Szpetkowski
Дата: