Received: from malur.postgresql.org ([217.196.149.56])
	by arkaria.postgresql.org with esmtp (Exim 4.72) (envelope-from
	<pgsql-general-owner+M197399=pgsql-general-arkari@postgresql.org>)
	id 1Uedvy-00066D-EI for pgsql-general@arkaria.postgresql.org;
	Tue, 21 May 2013 04:12:22 +0000
Received: from localhost ([127.0.0.1] helo=postgresql.org)
	by malur.postgresql.org with smtp (Exim 4.72) (envelope-from
	<pgsql-general-owner+M197399=pgsql-general-arkari@postgresql.org>)
	id 1Uedvx-0004W1-PJ for pgsql-general@arkaria.postgresql.org;
	Tue, 21 May 2013 04:12:21 +0000
Received: from makus.postgresql.org ([2001:4800:7903:4::125])
	by malur.postgresql.org with esmtp (Exim 4.72)
	(envelope-from <atri.jiit@gmail.com>)
	id 1Uedvv-0004Vo-5s; Tue, 21 May 2013 04:12:19 +0000
Received: from mail-pd0-f178.google.com ([209.85.192.178])
	by makus.postgresql.org with esmtp (Exim 4.72)
	(envelope-from <atri.jiit@gmail.com>)
	id 1Uedvo-0007Tm-1g; Tue, 21 May 2013 04:12:18 +0000
Received: by mail-pd0-f178.google.com with SMTP id w16so188802pde.9
	for <multiple recipients>; Mon, 20 May 2013 21:12:10 -0700 (PDT)
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20120113;
	h=references:mime-version:in-reply-to:content-type
	:content-transfer-encoding:message-id:cc:x-mailer:from:subject:date
	:to; bh=5Ssr/gMiIogYOL2/RJye5zvYvpgpPbHhJh4N9OZX1N4=;
	b=SPjIEMgcwqs46fjMiFMdljohDenCbV0M4B2CzRxTflNlY1LKl5mM5HH2bOEwsoGozH
	3Xk2BpbgiITCv4OmF+2NfcgJk5/kMpDegR8uXf6UPM+CLX/+VI3MhZ+BUx4benx6a+55
	PcXR0Py10f+ETYEzrrtKtm/mGNi4zJK4Uv+ZaWXtn/mQ8fbpTbtQj1ulAWPsH3RTuwAm
	sVkCzqH+DDK57RdTTpwsj9cRsT3zSgF0ShQqazrmHzilpgyCeA2NbOUgG6HkEOC0bk50
	Tlv2VNYS3C0B5Re09h3uL8qdXYMtCvjBezchANmvzpllSTxBbZt1bfvBJDVCsAx1ZuKi
	r9ig==
X-Received: by 10.68.225.170 with SMTP id rl10mr659582pbc.152.1369109530904;
	Mon, 20 May 2013 21:12:10 -0700 (PDT)
Received: from [192.168.1.2] ([122.177.226.8])
	by mx.google.com with ESMTPSA id if5sm906016pbb.31.2013.05.20.21.12.07
	for <multiple recipients>
	(version=TLSv1 cipher=ECDHE-RSA-RC4-SHA bits=128/128);
	Mon, 20 May 2013 21:12:10 -0700 (PDT)
References: 
 <CALSLE1MARsmPHrRi2jtYDrZz80JQnx8kMjaAh5UGHMNUcoMh3g@mail.gmail.com>
	<CALSLE1N=E5XmNHn6AS=7OXMGmC379+vvuBH1Vv5Sin4fPJog+A@mail.gmail.com>
	<CALSLE1NfessvrQvwGCy_LBaz4pkaeLAJOwFqmYPgH-cF5wOzRw@mail.gmail.com>
Mime-Version: 1.0 (1.0)
In-Reply-To: 
 <CALSLE1NfessvrQvwGCy_LBaz4pkaeLAJOwFqmYPgH-cF5wOzRw@mail.gmail.com>
Content-Type: multipart/alternative;
	boundary=Apple-Mail-C8747352-329B-4D46-9127-90020FE23A17
Content-Transfer-Encoding: 7bit
Message-Id: <AD6CD285-763A-46AB-9825-31BF208AAFA4@gmail.com>
Cc: "pgsql-odbc@postgresql.org" <pgsql-odbc@postgresql.org>,
	"pgsql-general@postgresql.org" <pgsql-general@postgresql.org>
X-Mailer: iPad Mail (10A523)
From: Atri Sharma <atri.jiit@gmail.com>
Subject: Re: ODBC constructs
Date: Tue, 21 May 2013 09:42:06 +0530
To: Dev Kumkar <devdas.kumkar@gmail.com>
X-Pg-Spam-Score: 0.7 (/)
List-Archive: <http://archives.postgresql.org/pgsql-general>
List-Help: <mailto:majordomo@postgresql.org?body=help>
List-ID: <pgsql-general.postgresql.org>
List-Owner: <mailto:pgsql-general-owner@postgresql.org>
List-Post: <mailto:pgsql-general@postgresql.org>
List-Subscribe: <mailto:majordomo@postgresql.org?body=sub%20pgsql-general>
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-general>
X-Mailing-List: pgsql-general
Precedence: bulk
Sender: pgsql-general-owner@postgresql.org


--Apple-Mail-C8747352-329B-4D46-9127-90020FE23A17
Content-Type: text/plain;
	charset=us-ascii
Content-Transfer-Encoding: quoted-printable



Sent from my iPad

On 21-May-2013, at 6:15, Dev Kumkar <devdas.kumkar@gmail.com> wrote:

> Hello,
>=20
> My objective is to work with postgres from my linux box using C. Am not su=
re whether psqlODBC or libpq should be used.
> I was playing and used libpq successfully but not sure which route to go a=
nd whats the difference.
>=20
> Also Can you please let me know any mapping document which maps ODBC const=
ructs between sybase and postgres.
>=20
> Also list of ODBC constructs to be used with postgres.
>=20
> Thanks in advance!
>=20
> Regards...
>=20
> p.s. Am not sure if the earlier email was sent..sorry for spam in case it w=
as.
>=20
>=20
> On Mon, May 20, 2013 at 5:37 PM, Dev Kumkar <devdas.kumkar@gmail.com> wrot=
e:
>> Hello,
>>=20
>> My objective is to work with postgres from my linux box using C. Am not s=
ure whether psqlODBC or libpq should be used.
>> I was playing and used libpq successfully but not sure which route to go a=
nd whats the difference.
>>=20
>> Also Can you please let me know any mapping document which maps ODBC cons=
tructs between sybase and postgres.
>>=20
>> Also list of ODBC constructs to be used with postgres.
>>=20
>>=20

If you are looking for a client to work with with your Postgres database,the=
n you can use psql(for command line),or use PGAdmin (http://www.pgadmin.org/=
).

If you are looking to connect data from your Sybase database to a Postgres d=
atabase,you can have a look at the various
Foreign data wrappers Postgres has.

If you wish to work in C,then,I would suggest libpq.I would wait for more re=
plies on this,as I have little knowledge
about psqlODBC.

Regards,

Atri



--Apple-Mail-C8747352-329B-4D46-9127-90020FE23A17
Content-Type: text/html;
	charset=utf-8
Content-Transfer-Encoding: quoted-printable

<html><head><meta http-equiv=3D"content-type" content=3D"text/html; charset=3D=
utf-8"></head><body dir=3D"auto"><div style=3D"-webkit-text-size-adjust: aut=
o; "><br><br>Sent from my iPad</div><div style=3D"-webkit-text-size-adjust: a=
uto; "><br>On 21-May-2013, at 6:15, Dev Kumkar &lt;<a href=3D"mailto:devdas.=
kumkar@gmail.com">devdas.kumkar@gmail.com</a>&gt; wrote:<br><br></div><block=
quote type=3D"cite" style=3D"-webkit-text-size-adjust: auto; "><div dir=3D"l=
tr"><div><div><div>Hello,<br><br></div><div>My objective is to work with pos=
tgres from my linux box using C. Am not sure whether psqlODBC or <a href=3D"=
http://www.postgresql.org/docs/9.2/static/libpq.html" target=3D"_blank">libp=
q</a> should be used.<br>


I was playing and used libpq successfully but not sure which route to go and=
 whats the difference.<br><br>Also Can you please let me know any mapping do=
cument which maps ODBC constructs between sybase and postgres.<br><br>


</div><div><div>Also list of ODBC constructs to be used with postgres.<br>
<br></div><div>Thanks in advance!<br></div><div><br></div>Regards...<br></di=
v></div></div><br>
p.s. Am not sure if the earlier email was sent..sorry for spam in case it wa=
s.<div class=3D"gmail_extra"><br><br><div class=3D"gmail_quote">On Mon, May 2=
0, 2013 at 5:37 PM, Dev Kumkar <span dir=3D"ltr">&lt;<a href=3D"mailto:devda=
s.kumkar@gmail.com" target=3D"_blank">devdas.kumkar@gmail.com</a>&gt;</span>=
 wrote:<br>

<blockquote class=3D"gmail_quote" style=3D"margin:0 0 0 .8ex;border-left:1px=
 #ccc solid;padding-left:1ex"><div dir=3D"ltr"><div><div>Hello,<br><br></div=
><div>My objective is to work with postgres from my linux box using C. Am no=
t sure whether psqlODBC or <a href=3D"http://www.postgresql.org/docs/9.2/sta=
tic/libpq.html" target=3D"_blank">libpq</a> should be used.<br>


I was playing and used libpq successfully but not sure which route to go and=
 whats the difference.<br><br>Also Can you please let me know any mapping do=
cument which maps ODBC constructs between sybase and postgres.<br><br>


</div><div><div>Also list of ODBC constructs to be used with postgres.<br>
<br></div><div><br></div></div></div></div>
</blockquote></div></div></div>
</blockquote><br><div style=3D"-webkit-text-size-adjust: auto; ">If you are l=
ooking for a client to work with with your Postgres database,then you can us=
e psql(for command line),or use PGAdmin (<span style=3D"font-size: 15px; lin=
e-height: 19px; white-space: nowrap; -webkit-tap-highlight-color: rgba(26, 2=
6, 26, 0.292969); -webkit-composition-fill-color: rgba(175, 192, 227, 0.2304=
69); -webkit-composition-frame-color: rgba(77, 128, 180, 0.230469); -webkit-=
text-size-adjust: none; "><a href=3D"http://www.pgadmin.org/">http://www.pga=
dmin.org/</a>).</span></div><div style=3D"-webkit-text-size-adjust: auto; ">=
<span style=3D"font-size: 15px; line-height: 19px; white-space: nowrap; -web=
kit-tap-highlight-color: rgba(26, 26, 26, 0.292969); -webkit-composition-fil=
l-color: rgba(175, 192, 227, 0.230469); -webkit-composition-frame-color: rgb=
a(77, 128, 180, 0.230469); -webkit-text-size-adjust: none; "><br></span></di=
v><div style=3D"-webkit-text-size-adjust: auto; "><span style=3D"font-size: 1=
5px; line-height: 19px; white-space: nowrap; -webkit-tap-highlight-color: rg=
ba(26, 26, 26, 0.292969); -webkit-composition-fill-color: rgba(175, 192, 227=
, 0.230469); -webkit-composition-frame-color: rgba(77, 128, 180, 0.230469); -=
webkit-text-size-adjust: none; ">If you are looking to connect data from you=
r Sybase database to a Postgres database,you can have a look at the various<=
/span></div><div style=3D"-webkit-text-size-adjust: auto; "><span style=3D"f=
ont-size: 15px; line-height: 19px; white-space: nowrap; -webkit-tap-highligh=
t-color: rgba(26, 26, 26, 0.292969); -webkit-composition-fill-color: rgba(17=
5, 192, 227, 0.230469); -webkit-composition-frame-color: rgba(77, 128, 180, 0=
.230469); -webkit-text-size-adjust: none; ">Foreign data wrappers Postgres h=
as.</span></div><div style=3D"-webkit-text-size-adjust: auto; "><span style=3D=
"font-size: 15px; line-height: 19px; white-space: nowrap; -webkit-tap-highli=
ght-color: rgba(26, 26, 26, 0.292969); -webkit-composition-fill-color: rgba(=
175, 192, 227, 0.230469); -webkit-composition-frame-color: rgba(77, 128, 180=
, 0.230469); -webkit-text-size-adjust: none; "><br></span></div><div style=3D=
"-webkit-text-size-adjust: auto; "><span style=3D"font-size: 15px; line-heig=
ht: 19px; white-space: nowrap; -webkit-tap-highlight-color: rgba(26, 26, 26,=
 0.292969); -webkit-composition-fill-color: rgba(175, 192, 227, 0.230469); -=
webkit-composition-frame-color: rgba(77, 128, 180, 0.230469); -webkit-text-s=
ize-adjust: none; ">If you wish to work in C,then,I would suggest libpq.I wo=
uld wait for more replies on this,as I have little knowledge</span></div><di=
v><span style=3D"font-size: 15px; line-height: 19px; white-space: nowrap; -w=
ebkit-tap-highlight-color: rgba(26, 26, 26, 0.292969); -webkit-composition-f=
ill-color: rgba(175, 192, 227, 0.230469); -webkit-composition-frame-color: r=
gba(77, 128, 180, 0.230469);">about psqlODBC.</span></div><div><span style=3D=
"font-size: 15px; line-height: 19px; white-space: nowrap; -webkit-tap-highli=
ght-color: rgba(26, 26, 26, 0.292969); -webkit-composition-fill-color: rgba(=
175, 192, 227, 0.230469); -webkit-composition-frame-color: rgba(77, 128, 180=
, 0.230469);"><br></span></div><div><span style=3D"font-size: 15px; line-hei=
ght: 19px; white-space: nowrap; -webkit-tap-highlight-color: rgba(26, 26, 26=
, 0.292969); -webkit-composition-fill-color: rgba(175, 192, 227, 0.230469); -=
webkit-composition-frame-color: rgba(77, 128, 180, 0.230469);">Regards,</spa=
n></div><div><span style=3D"font-size: 15px; line-height: 19px; white-space:=
 nowrap; -webkit-tap-highlight-color: rgba(26, 26, 26, 0.292969); -webkit-co=
mposition-fill-color: rgba(175, 192, 227, 0.230469); -webkit-composition-fra=
me-color: rgba(77, 128, 180, 0.230469);"><br></span></div><div><span style=3D=
"font-size: 15px; line-height: 19px; white-space: nowrap; -webkit-tap-highli=
ght-color: rgba(26, 26, 26, 0.292969); -webkit-composition-fill-color: rgba(=
175, 192, 227, 0.230469); -webkit-composition-frame-color: rgba(77, 128, 180=
, 0.230469);">Atri</span></div><div style=3D"-webkit-text-size-adjust: auto;=
 "><span style=3D"font-size: 15px; line-height: 19px; white-space: nowrap; -=
webkit-tap-highlight-color: rgba(26, 26, 26, 0.292969); -webkit-composition-=
fill-color: rgba(175, 192, 227, 0.230469); -webkit-composition-frame-color: r=
gba(77, 128, 180, 0.230469); -webkit-text-size-adjust: none; "><br></span></=
div><div style=3D"-webkit-text-size-adjust: auto; "><br></div></body></html>=

--Apple-Mail-C8747352-329B-4D46-9127-90020FE23A17--