PostgreSQL Tips

• 导出数据到csv 语法：

Copy (Select * From foo) To '/tmp/test.csv' With CSV DELIMITER ','  with csv header;

• 查看数据库的当前链接 语法：

select datname,application_name,cast(client_addr as text),query from pg_stat_activity order by datname;