> > 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 Blog: http://raghavt.blogspot.com/ On Wed, Sep 7, 2011 at 8:50 PM, shuaixf <shua...@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 >
