From: | Ron Johnson <ron(dot)l(dot)johnson(at)cox(dot)net> |
---|---|
To: | pgsql-interfaces(at)postgresql(dot)org |
Subject: | Re: libpq - description of columns |
Date: | 2002-05-23 16:03:52 |
Message-ID: | 1022169833.22629.12.camel@rebel |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-interfaces |
On Thu, 2002-05-23 at 09:26, Tom Lane wrote:
> Christian Gregoire <cgregoir99(at)yahoo(dot)com> writes:
> > Using '\d TABLENAME', psql gives me
> > character(15)
> > for a column, when libpq API PQfsize returns -1 for
> > the same column, whereas -1 should only indicate
> > fields with variable size (like TEXT i guess). Any
> > idea ?
>
> Yes, char(N) is considered a variable-length type. (Think about
> multibyte encodings to see why this must be so.) psql is looking
So it is only to the "user" that pg says "char() is fixed-length"?
--
+---------------------------------------------------------+
| Ron Johnson, Jr. Home: ron(dot)l(dot)johnson(at)cox(dot)net |
| Jefferson, LA USA http://ronandheather.dhs.org:81 |
| |
| "I have created a government of whirled peas..." |
| Maharishi Mahesh Yogi, 12-May-2002, |
! CNN, Larry King Live |
+---------------------------------------------------------+
From | Date | Subject | |
---|---|---|---|
Next Message | Denis Cartier Millon | 2002-05-24 14:12:32 | if exists / where exisyts.... |
Previous Message | Tom Lane | 2002-05-23 14:26:02 | Re: libpq - description of columns |