From: | Peter T Mount <peter(at)retep(dot)org(dot)uk> |
---|---|
To: | Philippe Chaintreuil <peep(at)thefront(dot)com> |
Cc: | pgsql-interfaces(at)postgresql(dot)org |
Subject: | Re: [INTERFACES] Getting max. value size (libpq++) |
Date: | 1999-07-01 05:58:55 |
Message-ID: | Pine.LNX.4.04.9907010654170.31519-100000@maidast.retep.org.uk |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-interfaces |
On Thu, 1 Jul 1999, Philippe Chaintreuil wrote:
> Okay, maybe I'm just not finding it in the documentation, but is
> there a way to find out the max size of a field? Specifically VARCHAR
> fields. For instance if I have a table created with the SQL code:
>
> CREATE TABLE temp_table
> ( name VARCHAR(30),
> id VARCHAR(10),
> address VARCHAR(60));
>
> Now the program I'm writing will add whatever the user wants to
> this table, of what ever size. I'm trying to avoid locking the size of
> the HTML input fields. So is there anyway to get those numbers back from
> Postgres? Right now they're hard-coded in, which really sucks. Thanks.
You need to query the system tables to do this.
Something like (I've not tested this, just lifting bits from the jdbc
source):
select a.attname,a.attlen from pg_attribute a,pg_class c
where c.relname like 'temp_table'
and a.attrelid=c.oid
and a.attnum>0
order by a.attnum;
Peter
--
Peter T Mount peter(at)retep(dot)org(dot)uk
Main Homepage: http://www.retep.org.uk
PostgreSQL JDBC Faq: http://www.retep.org.uk/postgres
Java PDF Generator: http://www.retep.org.uk/pdf
From | Date | Subject | |
---|---|---|---|
Next Message | Philippe Chaintreuil | 1999-07-01 08:42:00 | Getting max. value size (libpq++) |
Previous Message | Peter T Mount | 1999-07-01 05:49:51 | Re: [INTERFACES] storing java objects |