li_001的博客

连接数据库, 默认的用户和数据库是postgrespsql -U user -d dbname切换数据库,相当于mysql的use dbname\c dbname列举数据库，相当于mysql的show databases\l列举表，相当于mysql的show tables\dt查看表结构，相当于desc tblname,show columns from tbname\d tblname\di 查看

将psql 输出结果导入到csv 首先确保文件 是否有写入的权限 Copy (SELECT departments.name AS 部门,users.name AS 员工 ,COUNT(*) as 总数 FROM customers INNER JOIN users ON users.id = customers.user_id JOIN departments ON users.departme

sudo -u postgres psql postgres

default: &default adapter: postgresql encoding: unicode # For details on connection pooling, see rails configuration guide # http://guides.rubyonrails.org/configuring.html#database-pooling po