I've been using PostgreSQL and DBI just fine for a few months now.

The implementation has a few edges that need polishing and work, but the
basics work just fine for the julia 0.4.x branch.

The problem you ran into with fetchdf() not being implemented is that you
tried to run it on the stmt (before running execute). This is one of the
rough edges that not all convenience functions are implemented. In short, I
just confirmed the following example runs on julia 0.4.5 and the latest
DBI.jl / PostgreSQL.jl:

# slightly modified example from https://github.com/JuliaDB/PostgreSQL.jl

using DBIusing PostgreSQL

conn = connect(Postgres, "localhost", "username", "password", "dbname", 5432)
stmt = prepare(conn, "SELECT 1::bigint, 2.0::double precision,
'foo'::character varying, " *
                     "'foo'::character(10);")
result = execute(stmt) # this was missing in your use!
df = fetchdf(result)finish(stmt)
disconnect(conn)


Perhaps that helps clarify? Happy to help further, here or offline.

Cameron

Reply via email to