Skip site navigation (1) Skip section navigation (2)

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

From: John DeSoi <desoi(at)pgedit(dot)com>
To: Tomasz Myrta <jasiek(at)klaster(dot)net>
Cc: pgsql-interfaces(at)postgresql(dot)org
Subject: Re: Connect to a PostgreSQL-Server by TCP/IP
Date: 2005-08-10 18:30:23
Message-ID: 3624362A-B592-4C4E-9FAF-E596C8D8D704@pgedit.com (view raw or flat)
Thread:
Lists: pgsql-interfaces
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


In response to

pgsql-interfaces by date

Next:From: DavidDate: 2005-08-10 20:22:14
Subject: Re: pgperl vs dbd-perl
Previous:From: Johan C. de KoningDate: 2005-08-10 12:12:15
Subject: Re: Getting oid with libpq

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group