top of page

PostgreSQL DBMS table columns  

List of columns for the selected PostgreSQL table. It also displays additional information about the system columns of the table in a separate "SYSTEM COLUMN" node.  

PostgreSQL table column list

Child nodes

  • Default - value inserted into the default column

  • Not null - pointer to permission to insert Null value

  • Collation - sorting rule for the column

SELECT a.attname as column_name,
      pg_catalog.format_type(a.atttypid, a.atttypmod) as data_type,
      (SELECT substring(pg_catalog.pg_get_expr(d.adbin, d.adrelid, true) for 128)
         FROM pg_catalog.pg_attrdef d 
         WHERE d.adrelid = a.attrelid AND d.adnum = a.attnum AND a.atthasdef)  "def",
      a.attnotnull::int "attnotnull",
      (SELECT c.collname
         FROM pg_catalog.pg_collation c,
              pg_catalog.pg_type t
         WHERE c.oid = a.attcollation
           AND t.oid = a.atttypid
           AND a.attcollation <> t.typcollation) AS attcollation
 FROM pg_catalog.pg_attribute a
WHERE a.attrelid = $$TABLE_OID AND NOT a.attisdropped
ORDER BY a.attnum

bottom of page