variables show help on special variables \h [NAME] help on syntax of SQL commands, * for all commands Query Buffer \e [FILE] [LINE] edit the query buffer (or file) with external editor \ef [FUNCNAME [LINE]] edit function definition with external editor \ev [VIEWNAME [LINE]] edit v...
Postgresql数据库系统表和系统视图以及show命令 系统表 pg_class 该系统表记录了数据表、索引(仍然需要参阅pg_index)、序列、视图、复合类型和一些特殊关系类型的元数据。注意:不是所有字段对所有对象类型都有意义。 见如下应用示例: -- 查看指定表对象testtable的模式postgres=#SELECTrelname,relnamespace,nspnameFROMp...
\ev [VIEWNAME [LINE]] edit view definition with external editor \p show the contents of the query buffer \r reset (clear) the query buffer \s [FILE] display history or save it to file \w FILE write query buffer to file Input/Output \copy ... perform SQL COPY with...
| CALLED ON NULL INPUT | RETURNS NULL ON NULL INPUT | STRICT | [ EXTERNAL ] SECURITY INVOKER | [ EXTERNAL ] SECURITY DEFINER | AS 'definition' | AS 'obj_file', 'link_symbol' } ... [ WITH ( attribute [, ...] ) ]SQL CREATE GROUP语句: 语法: CREATE GROUP name [ [ WITH ] opt...
(window_definition)[,...]][{UNION|INTERSECT|EXCEPT}[ALL|DISTINCT]select][ORDERBYexpression[ASC|DESC|USINGoperator][NULLS{FIRST|LAST}][,...]][LIMIT{count|ALL}][OFFSETstart[ROW|ROWS]][FETCH{FIRST|NEXT}[count]{ROW|ROWS}ONLY][FOR{UPDATE|NOKEYUPDATE|SHARE|KEYSHARE}[OFtable_name[,...]][...
\ef [FUNCNAME [LINE]] edit function definition with external editor \ev [VIEWNAME [LINE]] edit view definition with external editor \p show the contents of the query buffer \r reset (clear) the query buffer \s [FILE] display history or save it to file ...
View definition: SELECT t.id, t.mc FROM t; postgres=# alter table t rename to t_new; ALTER TABLE Time: 62.875 ms postgres=# alter table t_new rename mc tomc_new; ALTER TABLE Time: 22.081 ms postgres=# \d+ t_view View"tbase.t_view" Column | Type | Collation | Nullable |...
\ef [FUNCNAME [LINE]] edit function definition with external editor \p show the contents of the query buffer \r reset (clear) the query buffer \s [FILE] display history or save it to file \w FILE write query buffer to file Input/Output ...
with external editor \ef [FUNCNAME [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] ...
\ev[VIEWNAME[LINE]]edit view definition with external editor \p show the contents of the query buffer \r reset(clear)the query buffer \s[FILE]display historyorsave it to file \wFILEwrite query buffer to fileInput/Output\copy...performSQLCOPYwith data stream to the client host ...