Postgres Quick Reference
Convert a column datatype from varchar (String) to int
alter table usercard alter column issueNumber type int
USING( TO_NUMBER(issueNumber,'999999999') );
$ stats_command_string = true
$ pg_ctl reload
SELECT datname,procpid,current_query FROM pg_stat_activity;
SELECT datname,procpid,current_query FROM pg_stat_activity
ORDER BY procpid ;