这篇文章主要介绍PostgreSQL常用命令有哪些，文中介绍的非常详细，具有一定的参考价值，感兴趣的小伙伴们一定要看完！
计算
安全
数据库
网络和加速
企业服务
mydb=# SELECT version();
version
-------------------------------------------------------------------------------------------------------
PostgreSQL 9.3.6 on i686-pc-linux-gnu, compiled by gcc (GCC) 4.4.6 20110731 (Red Hat 4.4.6-3), 32-bit
(1 row)mydb=# CREATE DATABASE test;
CREATE DATABASEmydb-# \l
List of databases
Name | Owner | Encoding | Collate | Ctype | Access privileges
-----------+---------+----------+-------------+-------------+---------------------
mydb | postgre | UTF8 | zh_CN.UTF-8 | zh_CN.UTF-8 |
postgres | postgre | UTF8 | zh_CN.UTF-8 | zh_CN.UTF-8 |
template0 | postgre | UTF8 | zh_CN.UTF-8 | zh_CN.UTF-8 | =c/postgre +
| | | | | postgre=CTc/postgre
template1 | postgre | UTF8 | zh_CN.UTF-8 | zh_CN.UTF-8 | =c/postgre +
| | | | | postgre=CTc/postgre
test | postgre | UTF8 | zh_CN.UTF-8 | zh_CN.UTF-8 |
(5 rows)mydb-# \c test
Password for user postgre:
You are now connected to database "test" as user "postgre".# 不能删除当前连接的数据库
test=# DROP DATABASE test;
ERROR: cannot drop the currently open database
test=# DROP DATABASE mydb;
DROP DATABASEtest=# create table t as select * from pg_tablespace;
SELECT 2
test=# \dt
List of relations
Schema | Name | Type | Owner
--------+------+-------+---------
public | t | table | postgre
(1 row)test=# \d t
Table "public.t"
Column | Type | Modifiers
------------+-----------+-----------
spcname | name |
spcowner | oid |
spcacl | aclitem[] |
spcoptions | text[] |test=# alter table t rename to t_t;
ALTER TABLE
test=# \dt
List of relations
Schema | Name | Type | Owner
--------+------+-------+---------
public | t_t | table | postgre
(1 row)# 创建索引
test=# create index idx_name on t (spcname);
CREATE INDEX
# 显示索引
test=# \di ;
List of relations
Schema | Name | Type | Owner | Table
--------+----------+-------+---------+-------
public | idx_name | index | postgre | t
public | idx_t | index | postgre | t_t
(2 rows)test=# drop table t_t;
DROP TABLEtest=# CREATE USER svoid;
CREATE ROLE
# 创建sovid 指定密码
test=# CREATE USER svoid WITH PASSWORD '123qwe';
CREATE ROLEtest=# SELECT usename FROM pg_user;
usename
---------
postgre
svoid
(2 rows)
test=# \du;
List of roles
Role name | Attributes | Member of
-----------+------------------------------------------------+-----------
postgre | Superuser, Create role, Create DB, Replication | {}
svoid | | {}test=# DROP USER svoid;
DROP ROLEtest=# \dn;
List of schemas
Name | Owner
--------+---------
public | postgre
(1 row)test=# CREATE SCHEMA myschema;
CREATE SCHEMAtest=# DROP SCHEMA myschema;
DROP SCHEMA以上是“PostgreSQL常用命令有哪些”这篇文章的所有内容，感谢各位的阅读！希望分享的内容对大家有帮助，更多相关知识，欢迎关注亿速云行业资讯频道！
亿速云「云服务器」，即开即用、新一代英特尔至强铂金CPU、三副本存储NVMe SSD云盘，价格低至29元/月。点击查看>>
免责声明：本站发布的内容（图片、视频和文字）以原创、转载和分享为主，文章观点不代表本网站立场，如果涉及侵权请联系站长邮箱：is@yisu.com进行举报，并提供相关证据，一经查实，将立刻删除涉嫌侵权内容。
原文链接：http://blog.itpub.net/30936525/viewspace-2097938/
