摘要：--登录数据库psql -h localhost -U pvincent -d chezhu--显示数据库vincent=# \l --切换数据库vincent=# \c chezhu You are now connected to database "chezhu" as user "vincent".--显示表chezhu=# \dt List of relations Schema | Name | Type | Owner --------+-----------------------... 阅读全文

摘要：1、下载Postgres93.zip解压，然后拖到应用mac系统的应用程序中，双击后Postgres93,会有导航栏中出现大象的图标，然后点击Open psql出现一个命令窗口输入CREATE ROLE pvincent;//创建一个角色ALTER ROLE pvincent password '123'//修改用户密码ALTER ROLE pvincent WITH LOGIN //给用户登录权限2、登录a.用命令行登录下载PG Commander客服端用于连接psql数据库http://postgresapp.com/documentation 阅读全文