#!/usr/local/bin/pgbash
 function E {
       exec_sql "$*"
 }
  E "select * from test"

 #!/usr/local/bin/pgbash
 exec  2>&1 
 echo "Content-type: text/html"
 echo ""
 exec_sql  -i

  exec_sql "connect to admin"
  exec_sql "connect to admin@www.psn.co.jp:5432"

 #!/usr/local/bin/pgbash
 exec 2>&1    ................ pgbashの標準エラー出力を標準出力に切り替える
 echo "Content-type: text/html"
 echo ""
 exec_sql  -i ................ HTML出力、GET/POSTのデータ処理

 #!/usr/local/bin/pgbash
 exec 2>&1
 echo "Content-type: text/html"
 echo "Set-Cookie: key11=111"
 echo "Set-Cookie: kei22=222"
 echo ""
 exec_sql  -i
 # 
 declares -i x; let x=0; while(( x < HTTP_NCOOKIE ))
 do
        echo "${HTTP_COOKIEKEY[x] = ${HTTP_COOKIEVAL[x]}"
	let x=x+1
 done

  begin;
  declare cur cursor for select * from test;
  fetch in cur into :aaa :aaa_indi, :bbb :bbb_indi;
  if(( aaa_indi == SQL_NULL )); then
     ...
  fi
  end;

 copy table_name from STDIN;             ................ COPY文の入力
 Enter info followed by a newline        ................ システムメッセージ
 End with a backslash and a period on a line by itself.
 >>
 111	namae1	jyuusyo1                 ................ データを入力
 222	namae2	jyuusyo2
 \.                                      ................ 終了記号
 

 #!usr/local/bin/pgbash
 copy table_name from STDIN; &> /dev/null << EOF
 111	namae1	jyuusyo1                 ................ データを入力
 222	namae2	jyuusyo2
 EOF                                     ................ 終了記号

   copy table_name( 列名１, 列名２, .. ) to '/tmp/test.dat';
 

exec_sql -N '-NULL-' -Z '-0-' "select * from test"

code  |name      |address
------+----------+--------
222   |test2     |addr2
333   |          |-0-
444   |-NULL-    |-NULL-
(3 rows)

  select * from test;
  declares -i x; let x=0; while(( x < SQLNFIELD ))
  do
      echo "NAME=${SQLFIELDNAME[x]}"
      let x=x+1
  done