Postgres Pro
Downloads
Home   >   mailing lists

Where does catalog store CHAR length ? - Mailing list pgsql-hackers

From phd9110
Subject Where does catalog store CHAR length ?
Date
Msg-id 001f01c3b7f6$58acbfe0$6c0d788c@husky
Whole thread Raw
Responses Re: Where does catalog store CHAR length ?  (Alvaro Herrera <alvherre@dcc.uchile.cl>)
List pgsql-hackers
Tree view
hi
 the table pg_attribute have the attribute  "attlen" , and this attribute will
store the attribute length. For example , when integer , this value will be 4.
But if attribute type is Char(xx), this value will be -1. This is because it
reference the bychar in pg_type table.

So, where is the Char() length information store ??
and what time will system check this string length constraint ?

thanks for your help!
Kao , Nchu Taiwan

pgsql-hackers by date:

Previous
From: Oliver Elphick
Date:
Subject: Re: initdb should create a warning message [was Re:
Next
From: Peter Eisentraut
Date:
Subject: Foreign key data type mismatches