pgsql常用命令汇总

压缩备份

pg_dump -h ${host} -p ${port} -U ${user} -F d -j 10 -d ${database} -Ow -f ${file_path} 

压缩备份恢复

pg_restore -h 127.0.0.1 -d ${data_name} -p ${port} -U ${user} -c -v -F d -j 8 ./test_dir

表格增加字段

ALTER TABLE ${table_name} ADD COLUMN ${column_name} text DEFAULT '';

获取一张表格的所有字段名字

select attname from pg_catalog.pg_attribute where 
       attstattarget = -1 and 
       attrelid in 
       (select oid from pg_catalog.pg_class where 
       relname='${table_name}')