For example: CREATE TABLE tb(name varchar(32)); 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@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin