gitlab里面postgresql几个操作

\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