#!/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 ""
 set EXEC_SQL_OPTION CGI;

  connect to admin;
  connect to admin@www.psn.co.jp:5432;

 #!/usr/local/bin/pgbash
 exec 2>&1    ................ pgbashの標準エラー出力を標準出力に切り替える
 echo "Content-type: text/html"
 echo ""
 set EXEC_SQL_OPTION CGI; .... 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 ""
 set EXEC_SQL_OPTION CGI;
 # 
 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;

   pgbash> E+
   pgbash> ?l
   [ List of databases ]
   ########## QUERY ##########
   SELECT  pg_database.datname as "Database", pg_user.usename as "Owner",
     pg_encoding_to_char(pg_database.encoding) as "Encoding"
    FROM pg_database, pg_user
    WHERE pg_database.datdba = pg_user.usesysid
    UNION
    SELECT pg_database.datname as "Database", NULL as "Owner",
     pg_encoding_to_char(pg_database.encoding) as "Encoding"
    FROM pg_database
    WHERE pg_database.datdba NOT IN (SELECT usesysid FROM pg_user)
    ORDER BY "Database"
   ###########################
 
   Database |Owner   |Encoding
   ---------+--------+---------
   admin    |postgres|EUC_JP
   postgres |postgres|SQL_ASCII
   template0|postgres|SQL_ASCII
   template1|postgres|SQL_ASCII

 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';
 

set OPTION_NULLSTRING="-NULL-";
set OPTION_ZEROSTRING="-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