Re: Getting lengths of variable fields

From: Michelle Murrain <mpm(at)norwottuck(dot)com>
To: pgsql-general(at)postgresql(dot)org
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Getting lengths of variable fields
Date: 2001-03-05 23:04:20
Message-ID: 01030518042000.14249@chicago.murrain.net
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Monday 05 March 2001 05:55 pm, Tom Lane wrote:

> What Michelle seems to want is the declared limit on field width, not
> the actual width of any particular value.

Yes, that's exactly what I want.

> This info is stored in the 'atttypmod' field of pg_attribute, but I
> don't know whether DBD::Pg provides any handy interface to that. You
> might have to get down-and-dirty enough to select it directly out of
> pg_attribute ...

I couldn't seem to find it - and I'm going to show my naivete here - how do I
get hold of it if there is no interface in DBD::Pg?

THanks!!

Michelle
------------
Michelle Murrain, Ph.D.
President
Norwottuck Technology Resources
mpm(at)norwottuck(dot)com
http://www.norwottuck.com

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Ted Gervais 2001-03-05 23:40:27 System V IPC semaphore configuration.
Previous Message David Wall 2001-03-05 23:03:15 Re: upper() vs. lower()