[ADMIN] how can I get the length of columns of a table by system tables/views

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.nabbl

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

SELECT a.attname, pg_catalog.format_type(a.atttypid, a.atttypmod) FROM pg_catalog.pg_attribute a WHERE a.attrelid = (SELECT pg_class.oid FROM pg_class INNER JOIN pg_namespace ON (pg_class.relnamespace = pg_namespace.oid AND

Re: [ADMIN] Could the unlogged table of postgresql be used as session?

which friend knows? -- View this message in context: http://postgresql.1045698.n5.nabble.com/Could-the-unlogged-table-of-postgresql-be-used-as-session-tp5710923p5711376.html Sent from the PostgreSQL - admin mailing list archive at Nabble.com. -- Sent via pgsql-admin mailing list (pgsql-admin@po