\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...
GRANT USAGE ON SEQUENCE myseq1, myseq2 TO readwrite; -- You can also grant permission to all sequences using the following SQL statement: GRANT USAGE ON ALL SEQUENCES IN SCHEMA myschema TO readwrite; -- To automatically grant permissions to sequences added in the future: ALTER DEFAULT PR...
-procs LIST 导入以逗号分隔的存储过程列表。 -allFuncs 导入所有函数。 -funcs LIST 导入以逗号分隔的函数列表。 -allPackages 导入所有包。 -packages LIST 导入以逗号分隔的包列表。 -allSequences 导入所有序列。 -sequences LIST 导入以逗号分隔的序列列表。 -targetSchema NAME ...
\drds [PATRN1 [PATRN2]] list per-database role settings \dRp[+] [PATTERN] list replication publications \dRs[+] [PATTERN] list replication subscriptions \ds[S+] [PATTERN] list sequences \dt[S+] [PATTERN] list tables \dT[S+] [PATTERN] list data types \du[S+] [PATTERN] list roles...
# relkind can be a list of the following options: # r(ordinary table), i(index), S(sequence), t(TOAST table), p(partitioned table), # m(materialized view), c(composite type), f(foreign table) # [[inputs.postgresql.relations]] ...
[LINE]] edit function definition with external editor...Informational (options: S = show system objects, + = additional detail) \d[S+] list tables, views, and sequences \d[S+] NAME describe table, view, sequence, or index \da[S] [PATTERN] list aggregates \dA...
# relkind can be a list of the following options: # r(ordinary table), i(index), S(sequence), t(TOAST table), p(partitioned table), # m(materialized view), c(composite type), f(foreign table) # [[inputs.postgresql.relations]] ...
CASE c.relkind WHEN 'r' THEN 'table' WHEN 'v' THEN 'view' WHEN 'm' THEN 'materialized view' WHEN 'S' THEN 'sequence' WHEN 'f' THEN 'foreign table' END as "Type", pg_catalog.array_to_string(c.relacl, E'\n') AS "Access privileges", ...
# relkind can be a list of the following options: # r(ordinary table), i(index), S(sequence), t(TOAST table), p(partitioned table), # m(materialized view), c(composite type), f(foreign table) # [[inputs.postgresql.relations]] ...
\o [FILE] send all query results to file or |pipe \qecho [STRING] write string to query output stream (see \o)Informational (options: S = show system objects, + = additional detail)\d[S+] list tables, views, and sequences ...