postgresql基本语句

preface,熟悉pgsql sql Language article disorder;

1,pgsql数据库控制台Cli(command line interface) help mannual;

注意\g == ; terminate with semicolon to execute query

SQL command help

psql command help

2,基于shell创建psql 数据库及owner user

createuser,createdb --superuser 加此参数,在新建user登进psql看看命令提示符是=#(超级用户命令行提示符) 还是=>普通用户提示符;

3,显示当前用户下的表及表结构

4,切换数据库连接

mysql中是用use + dbName

[Note byRuiy tip memorize]

sudo -u postgres createuser --superuser dbuser

sudo -u postgres psql

\password dbuser

sudo -u postgres createdb -O dbuser exampledb

(使用psql control)

useradd ruiy;

sudo -U postgres -d postgres -h 127.0.0.1 -p 5432

create user ruiy with password '321';

create database ruiy owner ruiy;

grant all privileges on database ruiy to ruiy;

5,psql服务器监听设置及客户端连接

pg_ctl restart

巴特西