Re: Daily Digest V1 #377

Поиск
Список
Период
Сортировка
От Limin Liu
Тема Re: Daily Digest V1 #377
Дата
Msg-id 3AA42A8A.8D5954BD@pumpkinnet.com
обсуждение исходный текст
Список pgsql-general
>
> I'm writing a very robust validation script in perl for database entry. One
> of the things I'd like to do is check how large a field is, and make sure
> that the entry into that field isn't too big. Problem is, for variable length
> fields, DBD::Pg returns a -1 size, using the pg_size attribute.
>
> Is there something I am missing? Is there a way to get the size of variable
> length types using DBI/DBD::Pg, in particular, char() and varchar()?
>

Try this SQL (replace the 'table_name' and 'attribute_name').  This should give you the length of your varchar().

SELECT a.atttypmod-4 as length
FROM pg_class c, pg_attribute a, pg_type t
WHERE c.relname = 'table_name'
  AND a.attname = 'attribute_name'
  AND a.attnum > 0
  AND a.attrelid = c.oid
  AND a.atttypid = t.oid;

LM.Liu

В списке pgsql-general по дате отправления:

Предыдущее
От: Boulat Khakimov
Дата:
Сообщение: Re: Getting lengths of variable fields
Следующее
От: Tom Lane
Дата:
Сообщение: Re: Getting lengths of variable fields