PostgreSQL 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.jpg

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