gitlab里面postgresql几个操作
2016/02/25 13:05 于 数据分析 0
\h：查看SQL命令的解释，比如\h select。
\?：查看psql命令列表。
\l：列出所有数据库。
\c [database_name]：连接其他数据库。
\d：列出当前数据库的所有表格。
\d [table_name]：列出某一张表格的结构。
\du：列出所有用户。
\e：打开文本编辑器。
\conninfo：列出当前数据库和连接的信息。
切换到对应用户
[root@git-node4 ~]# su - gitlab-psql
登录到postgresql
-sh-4.1$ psql -d gitlabhq_production
psql (9.2.8)
Type "help" for help.
查看所有库
gitlabhq_production=# \l
List of databases
Name | Owner | Encoding | Collate | Ctype | Access privileges
---------------------+-------------+----------+---------+-------+---------------------------------
gitlabhq_production | gitlab | UTF8 | C | C |
postgres | gitlab-psql | UTF8 | C | C |
template0 | gitlab-psql | UTF8 | C | C | =c/"gitlab-psql" +
| | | | | "gitlab-psql"=CTc/"gitlab-psql"
template1 | gitlab-psql | UTF8 | C | C | =c/"gitlab-psql" +
| | | | | "gitlab-psql"=CTc/"gitlab-psql"
(4 rows)查看所有表
gitlabhq_production=# \dt
List of relations
Schema | Name | Type | Owner
--------+----------------------+-------+--------
public | application_settings | table | gitlab
public | broadcast_messages | table | gitlab
public | deploy_keys_projects | table | gitlab
public | emails | table | gitlab
public | events | table | gitlab
public | forked_project_links | table | gitlab
public | identities | table | gitlab
public | issues | table | gitlab
public | keys | table | gitlab
public | label_links | table | gitlab
public | labels | table | gitlab
public | members | table | gitlab
public | merge_request_diffs | table | gitlab
public | merge_requests | table | gitlab
public | milestones | table | gitlab
public | namespaces | table | gitlab
public | notes | table | gitlab
public | oauth_access_grants | table | gitlab
public | oauth_access_tokens | table | gitlab
public | oauth_applications | table | gitlab
public | projects | table | gitlab
public | protected_branches | table | gitlab
public | schema_migrations | table | gitlab
public | services | table | gitlab
public | snippets | table | gitlab
public | subscriptions | table | gitlab
public | taggings | table | gitlab
public | tags | table | gitlab
public | users | table | gitlab
public | users_star_projects | table | gitlab
public | web_hooks | table | gitlab
(31 rows)
以下SQL 基本和mysql一致：SELECT,UPDATE,INSERT,DELETE,CREATE,ALTER
