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

Lists: pgsql-hackers
From: Gordon Anderson <justgord(at)gmail(dot)com>
To: pgsql-hackers(at)postgresql(dot)org
Subject: how to trace the pgsql text format protocol [implementing driver]
Date: 2009-03-13 01:31:53
Message-ID: e8b0fe770903121831x4769cf95tfc5cc3a416d75b24@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Lists: pgsql-hackers

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


From: Heikki Linnakangas <heikki(dot)linnakangas(at)enterprisedb(dot)com>
To: Gordon Anderson <justgord(at)gmail(dot)com>
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: how to trace the pgsql text format protocol [implementing driver]
Date: 2009-03-13 05:49:44
Message-ID: 49B9F3F8.5090108@enterprisedb.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Lists: pgsql-hackers

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