Haskell で PosygreSQL(2)

読み込んでみる。

$ cat dbread.hs

import IO

import Database.HDBC

import Database.HDBC.PostgreSQL

 

main = do

    conn <- connectPostgreSQL "host=localhost port=5432 dbname=test"

    q <- quickQuery' conn "SELECT * from test" []

    print q

    disconnect conn

 

$ ghc -package HDBC -package HDBC-postgresql dbread.hs -o dbread

 

$ ./dbread

 [ [SqlInteger 0,SqlNull ] , [SqlInteger 123,SqlByteString "hoge" ] ]