|
username=> ?
? -- help
a --
toggle field-alignment (currently on)
C [<captn>] -- set html3 caption
(currently '')
connect <dbname|-> <user> -- connect to new
database (currently 'hidekijt')
copy table {from | to} <fname>
d
[<table>] -- list tables and indices, columns in <table>, or * for
all
da -- list aggregates
dd [<object>]- list comment for table,
field, type, function, or operator.
df -- list functions
di -- list only
indices
do -- list operators
ds -- list only sequences
dS -- list
system tables and indexes
dt -- list only tables
dT -- list types
e
[<fname>] -- edit the current query buffer or <fname>
E
[<fname>] -- edit the current query buffer or <fname>, and
execute
f [<sep>] -- change field separater (currently '|')
g
[<fname>] [|<cmd>] -- send query to backend [and results in
<fname> or pipe]
h [<cmd>] -- help on syntax of sql commands, *
for all commands
H -- toggle html3 output (currently off)
i <fname>
-- read and execute queries from filename
l -- list all databases
m --
toggle monitor-like table display (currently off)
o [<fname>]
[|<cmd>] -- send all query results to stdout, <fname>, or pipe
p
-- print the current query buffer
q -- quit
r -- reset(clear) the query
buffer
s [<fname>] -- print history or save it in <fname>
t --
toggle table headings and row count (currently on)
T [<html>] -- set
html3.0 <table ...> options (currently '')
x -- toggle expanded output
(currently off)
w <fname> -- output current buffer to a file
z --
list current grant/revoke permissions
! [<cmd>] -- shell escape or
command
username=> |
サポート
