Re: Getting lengths of variable fields - Mailing list pgsql-general

From Michelle Murrain
Subject Re: Getting lengths of variable fields
Date
Msg-id 01030519243001.14249@chicago.murrain.net
Whole thread Raw
In response to Re: Getting lengths of variable fields  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
On Monday 05 March 2001 05:55 pm, Tom Lane wrote:
>
> 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 ...

Ah, I got it. Just do a select. It's a system table I hadn't learned about
yet. And, I have to subtract 4 from it to get the real length. Thanks!!

Michelle
------------
Michelle Murrain, Ph.D.
President
Norwottuck Technology Resources
mpm@norwottuck.com
http://www.norwottuck.com

pgsql-general by date:

Previous
From: Marek Pętlicki
Date:
Subject: Re: Re: pgsql for Python
Next
From: Michelle Murrain
Date:
Subject: Re: Getting lengths of variable fields