Postgres Pro
Downloads
Home   >   mailing lists

Re: How to obtain the max length of a varchar(50) field. - Mailing list pgsql-novice

From Simon Riggs
Subject Re: How to obtain the max length of a varchar(50) field.
Date
Msg-id BANLkTi=0pKw7vvjWwdQWv1LMaDhRsj9Jfg@mail.gmail.com
Whole thread Raw
In response to How to obtain the max length of a varchar(50) field.  (Mauro Ziliani <mauro@faresoftware.it>)
Responses Re: How to obtain the max length of a varchar(50) field.  (Mauro Ziliani <mauro@faresoftware.it>)
List pgsql-novice
Tree view 
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 by date:

Previous
From: ALT SHN
Date:
Subject: Re: [GRASS-user] OCR
Next
From: Andreas Kretschmer
Date:
Subject: Re: How to obtain the max length of a varchar(50) field.