postgresql tips

postgresql修改密码

修改“/etc/postgresql/9.6/main/pg_hba.conf"

local   all    all   md5

修改密码

$ sudo service postgresql restart
$ sudo -u postgres psql
postgres=# \password postgres
postgres=# \q

恢复“/etc/postgresql/9.6/main/pg_hba.conf"

local   all    all   peer

psql常用命令

-- load data from csv
\copy {table_name} (column1, column2, ... ) from '/path/data.csv' with delimiter ','

-- data to csv
\copy ${table_name} to '${temp_path}/${table_name}.csv' delimiter ','

-- list schema
\dn

-- list table
\dt

-- description table
\d table_name

links

social