1. Tatsuya Sato
  2. ruby-pg

Source

ruby-pg / README.ja

                  PostgreSQL$BMQ3HD%%i%$%V%i%j(B  version 0.7.1

                                                             $B$^$D$b$H(B $B$f$-$R$m(B
                                                             $B$^$D$b$H(B $B$($$$8(B

                                                  $B@$OC?M(B:    $B@FF#(B $BEP(B
	
- What's this ?

$BK\%i%$%V%i%j$O!"(BRuby$B$+$i(BPostgreSQL$B$X%"%/%;%9$9$k$?$a$N3HD%%i%$%V%i%j$G$9!#(B
$B%5%]!<%H$7$F$$$k(BPostgreSQL$B$N%P!<%8%g%s$O!"(B6.5/7.0/7.1/7.2 $B$G$9!#(B6.3$B0JA0$N(B
$B%P!<%8%g%s$G$b(B($B$A$g$C$H$7$?JQ99$G(B)$BF0:n$9$k$H;W$$$^$9$,!"%F%9%H$7$F$$$^$;$s!#(B

- How to install ?
 *** requirement ***
 PostgreSQL module$B$r;H$&$s$G$9$+$i!$EvA3(BPostgreSQL$B$OI,MW$G$9$M!%:#$N$H$3$m(B
 $B%m!<%+%k$K(BPostgreSQL$B$,%$%s%9%H!<%k$5$l$F$$$k$3$H$rA0Ds$K$7$F$$$^$9$,!$(B
 $BI,MW$J%X%C%@$H(Blibpq$B$5$($"$l$P!$%5!<%P$OI,$:$7$b%m!<%+%k$GF0:n$7$F$$$kI,MW(B
 $B$O$"$j$^$;$s!%(B

 $B%G%U%)%k%H$G$O!$(BPostgreSQL$B$,(B/usr/local/pgsql$BG[2<$K%$%s%9%H!<%k$5$l$F$$$k(B
 $B$H$7$F$$$^$9!%JL$N>l=j$K%$%s%9%H!<%k$7$F$$$k>l9g$K$O!$4D6-JQ?t(BPGLIB$B$K(Blibpq
 $B%i%$%V%i%j$,CV$$$F$"$k(Bdirectory$B$K@_Dj$7$F2<$5$$!#(B

 $BG$0U$N>l=j$G!$$3$N%"!<%+%$%V$rE83+$7$F$/$@$5$$!%8e$O(B

  ruby extconf.rb
  make
  su               ($B$b$7I,MW$J$i(B)
  make install
 
 $B$H$9$k$@$1$G$9!%(BPostgreSQL$B$N%$%s%/%k!<%I%U%!%$%k!"%i%$%V%i%j%U%!%$%k$N(B
 $B%$%s%9%H!<%k>l=j$,I8=`$N0LCV$G$O$J$/%3%s%Q%$%i$,8+IU$1$k$3$H$,$G$-$J$$(B
 $B>l9g$K$O(B

    --with-pgsql-include-dir=<$B%$%s%/%k!<%I%U%!%$%k%G%#%l%/%H%j(B>
    --with-pgsql-lib-dir=<$B%i%$%V%i%j%G%#%l%/%H%j(B>
$B$^$?$O(B
    --with-pgsql-dir=<$B%G%#%l%/%H%j(B>
          $B$3$l$O0J2<$N$h$&$K;XDj$7$?$H$-$H$*$J$8$G$9!#(B
           --with-pgsql-include-dir=<$B%G%#%l%/%H%j(B>/include
           --with-pgsql-lib-dir=<$B%G%#%l%/%H%j(B>/lib


 $BNc$($P(B

  ruby extconf.rb --with-pgsql-include-dir=/usr/local/pgsql/include \
                  --with-pgsql-lib-dir=/usr/local/pgsql/lib
$B$^$?$O(B
  ruby extconf.rb --with-pgsql-dir=/usr/local/pgsql

 $B$N$h$&$K;XDj$7$F$/$@$5$$!#(B

- How to use ?

  require "postgres"

$B$H$7$F$+$i8f;HMQ2<$5$$!#(B

- What function can I use ?

$B4pK\E*$K!"(BC$B$N(Blibpq$B%$%s%?%U%'!<%9$GDj5A$5$l$F$$$k4X?t$O%5%]!<%H$7$F$$$^$9!#(B
ver 0.6.0 $B$+$i?7$7$/(B Large Object $B%$%s%?!<%U%'%$%9$,DI2C$5$l$^$7$?!#(B

$B%5%]!<%H$7$F$$$k%a%=%C%I$N0lMw$O0J2<$NDL$j$G$9!#(B

PGconn$B%/%i%9(B:

 $B%/%i%9%a%=%C%I(B
    new
    connect
    setdb
    setdblogin
    escape
    quote
    escape_bytea

 $B%a%=%C%I(B
    db
    host
    options
    port
    tty
    status
    error
    finish
    close
    reset
    user
    trace
    untrace

    exec
    query
    async_exec
    async_query
    get_notify
    insert_table
    putline
    getline
    endcopy
    notifies

    lo_import
    lo_export
    lo_create
    lo_open  
    lo_unlink

    client_encoding
    set_client_encoding

PGresult$B%/%i%9(B:

$B%a%=%C%I(B
    each
    []
    status
    result
    fields
    num_tuples
    num_fields
    fieldname
    fieldnum
    type
    size
    getvalue
    getlength
    cmdstatus
    print
    clear

PGlarge$B%/%i%9(B:

$B%a%=%C%I(B
    open
    close
    read
    write
    lseek
    tell
    unlink
    oid
    size
    export
    
- Acknowledgement

$BK\3HD%%i%$%V%i%j$r:n@.$9$k$K$"$?$C$F!"(Bruby-list, ruby-dev,
ruby-talk,$B5Z$S(B pgsql-jp$B%a!<%j%s%0%j%9%H$N%a%s%P!<$K!"B?$/$NM-1W$J(B
$B%"%I%P%$%9$rD:$-$^$7$?!#$3$3$K46<U$N0U$rI=$7$^$9!#(B

- Copying

$BK\3HD%%i%$%V%i%j$NCx:n8"$O!"$^$D$b$H(B $B$f$-$R$m$H$^$D$b$H(B $B$($$$8$,(B
$BJ];}$7$^$9!#(B

$BK\3HD%%i%$%V%i%j$O!"(BRuby$BK\BN$HF1$8G[I[>r7o$K=>$C$F:FG[I[$9$k$3$H(B
$B$,$G$-$^$9!#(BRuby$BK\BN$NG[I[>r7o$K$D$$$F$O!"(BRuby$BG[I[J*Cf$N(BREADME.jp
$B$K=q$+$l$F$$$^$9!#(B

$B8=:_$O@FF#(B $BEP$,(B maintainer $B$r>5$C$F$$$k$N$G!"Ld$$9g$o$;$O$3$A$i$NJ}$K(B
$B$*4j$$$7$^$9!#(B

- Author

 $B$^$D$b$H(B $B$f$-$R$m(B <matz@ruby-lang.org>
  Author of Ruby

 $B$^$D$b$H(B $B$($$$8(B <usagi@ruby.club.or.jp>
  One of users who loves Ruby

$B$3$N$U$?$j$O7;Do$G$O$"$j$^$;$s!#(B :-)

- Special Thanks

 Guy Decoux   ts <decoux@moulon.inra.fr>

- maintainer

  $B@FF#(B $BEP(B <noborus@netlab.jp>
  $B$^$D$b$H$G$J$/$F$9$$$^$;$s(B :-)