若要将制表符指定为定界符，请结合使用$和-F选项。
nzsql -o sample.txt -F $'t' -A -t -c "SELECt * FROM DW_ETL.USER WHERe datasliceid % 20 = 2 LIMIT 5;"
记录在nzsql -h输出中。
nzsql -hThis is nzsql, the IBM Netezza SQL interactive terminal.Usage: nzsql [options] [security options] [dbname [username] [password]]Security Options: -securityLevel Security Level you wish to request (default: preferredUnSecured) -caCertFile ROOT CA certificate file (default: NULL)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) -schema <schemaname> Specify schema name to connect to (default: $NZ_SCHEMA) -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=) For any binary/control/non-printable character use '$' (e.g., nzsql -F $'t' // for TAB)...
如果您有大量数据，建议您改用外部表，因为它们的性能更好。
CREATE EXTERNAL TABLE '/tmp/sample.txt' USING (DELIMITER 't') AS SELECt * FROM DW_ETL.USER WHERe datasliceid % 20 = 2 LIMIT 5;
