Postgres Pro
Downloads
Home   >   mailing lists

Re: how can I get the length of columns of a table by system tables/views - Mailing list pgsql-admin

From Raghavendra
Subject Re: how can I get the length of columns of a table by system tables/views
Date
Msg-id CA+h6AhhcnXmvDPXk2XzqRY8W7J+WKmALSen_rMcXT_38=P3_Sw@mail.gmail.com
Whole thread Raw
In response to how can I get the length of columns of a table by system tables/views  (shuaixf <shuaixf@gmail.com>)
Responses Re: how can I get the length of columns of a table by system tables/views
List pgsql-admin
Tree view
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 by date:

Previous
From: shuaixf
Date:
Subject: how can I get the length of columns of a table by system tables/views
Next
From: "marvin.deoliveira"
Date:
Subject: Foreign key without the column reference