Thread: how to trace the pgsql text format protocol [implementing driver]

how to trace the pgsql text format protocol [implementing driver]

From
Gordon Anderson
Date:
Hi,

I wish to implement a postgreSQL driver for a lisp-like language
[arclanguage.org] - it should speak the pg v2 text format protocol via
sockets I guess.

Im reading the v2 protocol spec, but it would be handy to trace the
exact text sent back and forth during a psql session - to help me
understand the protocol and test things out.

thanks in advance, [ and thanks for pg - its great, especially guids ]

gord


Re: how to trace the pgsql text format protocol [implementing driver]

From
Heikki Linnakangas
Date:
Gordon Anderson wrote:
> I wish to implement a postgreSQL driver for a lisp-like language
> [arclanguage.org] - it should speak the pg v2 text format protocol via
> sockets I guess.

You probably should go straight to v3. v2 is quite old by now.

> Im reading the v2 protocol spec, but it would be handy to trace the
> exact text sent back and forth during a psql session - to help me
> understand the protocol and test things out.

Wireshark has a PostgreSQL protocol dissector.

--   Heikki Linnakangas  EnterpriseDB   http://www.enterprisedb.com