count

 -------

     99

 (1 row)

 => select column_name, data_type, column_default, is_nullable from information_schema.columns where table_name='alpha';

  column_name | data_type | column_default | is_nullable

 -------------+-----------+----------------+-------------

  foo         | integer   |                | YES

  bar         | character |                | YES

 (2 rows)

 => select * from information_schema.information_schema_catalog_name;

  catalog_name

 --------------

  johnd

 (1 row)