Re: how can I get the length of columns of a table by system tables/views

Поиск
Список
Период
Сортировка
От Raghavendra
Тема Re: how can I get the length of columns of a table by system tables/views
Дата
Msg-id CA+h6AhhcnXmvDPXk2XzqRY8W7J+WKmALSen_rMcXT_38=P3_Sw@mail.gmail.com
обсуждение исходный текст
Ответ на how can I get the length of columns of a table by system tables/views  (shuaixf <shuaixf@gmail.com>)
Ответы Re: how can I get the length of columns of a table by system tables/views  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-admin
Дерево обсуждения
For example:
CREATE TABLE tb(name varchar(32));

You can get this with System functions.

select pg_column_size(name) from tb;

---
Regards,
Raghavendra
EnterpriseDB Corporation



On Wed, Sep 7, 2011 at 8:50 PM, shuaixf <shuaixf@gmail.com> wrote:

According to pg_class, pg_attribute, pg_type, I can get the tablename,
column name, column type
however, how to get the length of columns of a table by system tables/views?
Thanks!

--
View this message in context: http://postgresql.1045698.n5.nabble.com/how-can-I-get-the-length-of-columns-of-a-table-by-system-tables-views-tp4778911p4778911.html
Sent from the PostgreSQL - admin mailing list archive at Nabble.com.

--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin

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

Предыдущее
От: shuaixf
Дата:
Сообщение: how can I get the length of columns of a table by system tables/views
Следующее
От: "marvin.deoliveira"
Дата:
Сообщение: Foreign key without the column reference