postgresql 접속 방법 및 간단한 쿼리

- client access

psql -h <postgresql-end-point> -U <user> -d <database> -W

 

 

- database list

SELECT datname FROM pg_database WHERE datistemplate = false;

 

 

- process list

select * from pg_stat_activity;