exec_sql: exec_sql [option] ["SQL"] -i turn on CGI mode and set DATAs received from server --------------------- show infomations --------------------- -h item help {\"SQL\", ALL,OPTION,ERRCODE} -v show PostgreSQL and PGBASH VERSION -m show CONNECTION NAMEs -s show STATUS after executing SQL --------------------- temporary options -------------------- -d conn set CONNECTION NAME -e turn on ECHO query sent to the backend -q turn on QUIET system/sql error messages -P turn on PLAIN format(-P is default in normal mode) -H turn on HTML format(-H is default in CGI mode) -X turn on EXPANDED format -L turn on OUTER_FRAME of PLAIN text -T turn off TOP_header print -B turn off BOTTOM_count print -A turn off ALIGNMENT of PLAIN text(e.g. -PXA) -C cap set CAPTION of HTML/PLAIN table(e.g. -C 'TITLE') -O opt set OPTION of HTML table tag(e.g. -O 'BORDER=0') -S sep set SEPARATOR of PLAIN text field (default is '|') -N null set NULL_STRING(e.g. -N '*N*') -Z zero set ZERO_STRINg(e.g. -Z '*0*') --------------------- execute function -------------------- -x func execute func(e.g. lo_import, lo_export, lo_unlink)