Re: Connect to a PostgreSQL-Server by TCP/IP

On Aug 10, 2005, at 6:38 AM, Tomasz Myrta wrote:

> Fischer Ulrich napisal 2005-06-22 17:37:
>
>> Hello
>> I'm new in this List.
>> I would like to connect to a Postgres-Server by a LabView-Client.  
>> The problem is, there is NO odbc-driver for LV on Linux and no LV- 
>> interface to postgreSQL.
>> So I decided to make my own simple LabView driver. Are there some  
>> docs, which describes the basic communication over a tcp  
>> connection between the postgres server and a client? I'm  
>> interested in 'message architecture' (header, data for login, sql- 
>> querys and so on...) and all this stuff.
>>
> May I ask you, why do you want to make your own direct TCP  
> connection to PostgreSQL? I think, in your case it would be much  
> easier to create some wrapper for libpq or some other frontend  
> library. It needs less work and you don't have to be afraid about  
> tracking internal protocol changes.
>
>
>> I tried some backward engineering by sniffing the tcp connection,  
>> but it is rather anoying. It looks like the messages have some  
>> binary headers and they are a problem....
>>
> Maybe source code of common used PostgresSQL frontends like libpq  
> will help you?


PostgreSQL has a very nice and well documented protocol. See

http://www.postgresql.org/docs/8.0/static/protocol.html





John DeSoi, Ph.D.
http://pgedit.com/
Power Tools for PostgreSQL