options show help on psql command-line options \?variables show help on special variables \h [NAME] help on syntax of SQL commands,*forall commands Query Buffer \e [FILE] [LINE] edit the query buffer (or file) with external editor \ef [FUNCNAME [LINE]] edit function definition with ex...
eg:创建一个函数,声明foo表字段类型相同的变量CREATEFUNCTIONshow_table_foo()RETURNStextAS$$DECLAREfoo_row foo%ROWTYPE;BEGINSELECT*INTOfoo_rowfromfoowherefooid=1;RETURN'fooid :'||foo_row.fooid::text||' fooname :'||foo_row.fooname;END; $$LANGUAGEplpgsql;'::'强制转换符,相当于cast函数,如果...
\sf[+] FUNCNAME show a function's definition \z [PATTERN] same as \dp Formatting \a toggle between unaligned and aligned output mode \C [STRING] set table title, or unset if none \f [STRING] show or set field separator for unaligned query output \H toggle HTML output mode (currently...
\h [NAME] help on syntax of SQL commands, * for all commandsQuery Buffer \e [FILE] [LINE] edit the query buffer (or file) with external editor \ef [FUNCNAME [LINE]] edit function definition with external editor...Informational (options: S = show system objects, + = addi...
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 ... Informational (options: S =...
\?options show help on psql command-line options \?variables show help on special variables \h[NAME]help on syntax of SQL commands,*forall commands Query Buffer \e[FILE][LINE]edit the query buffer(or file)with external editor \ef[FUNCNAME[LINE]]editfunctiondefinition with external editor.....
* In the ROWS FROM syntax, a column definition list can be given for each * function, for example: * ROWS FROM (foo() AS (foo_res_a text, foo_res_b text), * bar() AS (bar_res_a text, bar_res_b text)) * It's also possible to attach a column definition list to the ...
SHOW 显示运行时参数的值。 SHOW name SHOW ALL START TRANSACTION 开始一个事务块。 START TRANSACTION [ transaction_mode [, ...] ] #transaction_mode 可以是下面的选项之一: ISOLATION LEVEL { SERIALIZABLE | REPEATABLE READ | READ COMMITTED | READ UNCOMMITTED } ...
以及下面的"Definition"->"Description"进行一下设置. 19. 在窗口标题栏内显示文件的完全路径 Tools->Preferences->User Interface->Options 勾选"Show complete file path in windows titles" 20. Object Brower中自定义Object的顺序以及登录后默认自动选中My Objects ...
\?options show help on psql command-line options \?variables show help on special variables \h[NAME]help on syntax ofSQLcommands,*forall commandsQueryBuffer\e[FILE][LINE]edit the query buffer(orfile)with external editor \ef[FUNCNAME[LINE]]edit function definition with external editor ...