"idx_emps" btree (salary) List all tables in database along with some additional information # \d+ List of relations Schema | Name | Type | Owner | Size | Description ---+---+---+---+---+--- public | users | table | jarvis | 401 MB | (1 row) Describe a table with addi...
postgres=# \df List of functionsSchema | Name | Result data type | Argument data types | Type---+---+---+---
Tolist tables in a PostgreSQL database, you can use the\dcommand to get the basic information or the\dt+command for the detailed information about the tables (if you add + to commands, you will get additional information in the output): To describe any specific table, execute\d tablename...
\dp [PATTERN] list table, view, and sequence access privileges \drds [PATRN1 [PATRN2]] list per-database role settings \ds[S+] [PATTERN] list sequences \dt[S+] [PATTERN] list tables \dT[S+] [PATTERN] list data types \du[+] [PATTERN] list roles \dv[S+] [PATTERN] list views...
\des[+] [PATTERN] list foreign servers \det[+] [PATTERN] list foreign tables \deu[+] [PATTERN] list user mappings \dew[+] [PATTERN] list foreign-data wrappers \df[anptw][S+] [FUNCPTRN [TYPEPTRN ...]] list [only agg/normal/procedure/trigger/window] functions ...
\det[+] [PATTERN] list foreign tables \des[+] [PATTERN] list foreign servers \deu[+] [PATTERN] list user mappings \dew[+] [PATTERN] list foreign-data wrappers \df[anptw][S+] [PATRN] list [only agg/normal/procedures/trigger/window] functions ...
SELECT tablename FROM pg_tables;WHERE tablename NOT LIKE 'pg%'AND tablename NOT LIKE 'sql_%'ORDER BY tablename;列出数据库名 \l 或 SELECT datname FROM pg_database;切换数据库 \c 数据库名 1、通过命令⾏查询 \d 数据库 —— 得到所有表的名字 \d 表名 —— 得到表结构 2、通过SQL语句...
psql: fatal: the database system is in recovery mode 这个错误信息表示你尝试连接的 PostgreSQL 数据库系统当前正处于恢复模式。在恢复模式下,数据库不允许普通的数据库连接,因为它正在从备份或日志中恢复数据。 2. 可能导致该错误出现的情境或操作 数据库崩溃后的恢复:当数据库系统由于某些原因(如硬件故障、操作...
\det[+] [PATTERN] list foreign tables \des[+] [PATTERN] list foreign servers \deu[+] [PATTERN] list user mappings \dew[+] [PATTERN] list foreign-data wrappers \df[antw][S+] [PATRN] list [only agg/normal/trigger/window] functions ...
pg_ctl register -N ‘postgresq-xx’ $PGDATA 注册服务,服务名为postgresql-xx Pg_ctl reload -D $PGDATA 重新加载配置、 1.2psql 语法 psql是PostgreSQL 的交互式客户端工具。 使用方法: psql [选项]... [数据库名称 [用户名称]] 通用选项: