Class::DBI::Pg automate the setup of Class::DBI columns and primary key for
Postgres.

select Postgres system catalog and find out all columns, primary key and SERIAL
type column.