netezza命令语法简要netezza命令语法简要.pdf

nzsql This is nzsql, the Netezza SQL interactive terminal. Usage: nzsql [options] [dbname [username] [password]] Options: -a Echo all input from script -A Unaligned table output mode (-P format=unaligned) -c query Run only single query (or slash command) and exit -d dbname Specify database name to connect to (default: system) -D dbname Specify database name to connect to (default: system) -e Echo queries sent to backend -E Display queries that internal commands generate -f filename Execute queries from file, then exit -F string Set field separator (default: |) (-P fieldsep=) -host host Specify database server host (default: domain socket) -H HTML table output mode (-P format=html) -l List available databases, then exit -n Disable readline -o filename Send query output to filename (or |pipe) -port port Specify database server port (default: hardwired) -P var[=arg] Set printing option var to arg (see \pset command) -q Run quietly (no messages, only query output) -R string Set record separator (default: newline) (-P recordsep=) -Rev Show version information and exit -rev Show version information and exit -s Single step mode (confirm each query) -S Single line mode (newline terminates query) -t Print rows only (-P tuples_only) -T text Set HTML table tag options (width, border) (-P tableattr=) -u username Specify database username (default: admin) -U username Specify database username (default: admin) -v name=val Set nzsql variable name to value -V Show version information and exit -W password Specify the database user password -pw password Specify the database us