From: CN LIOU <cnliou@graffiti.net>
To: pgsql-sql@postgresql.org
Subject: How To Get Bytea Data Instead Of Its Oid
Date: Thu, 19 Sep 2002 22:11:13 +0800
Message-ID: <20020919141116.13398.qmail@graffiti.net> (raw)
Greetings!
I must have missed lesson 1 of postgresql!
create table test (c1 text,c2 bytea);
Then, I probably have successfullyi nserted several records into test using C++Builder. Now I am trying to retrieve back the binary data in c2 I just inserted. However, the SQL statement issued by both C++Builder and psql:
SELECT * FROM test LIMIT 1
returns, I guess, the OID of c2 instead of the binary data to which the OID points.
What is the correct SQL syntax for C++Builder for bytea?
Regards,
--
_______________________________________________
Get your free email from http://www.graffiti.net
Powered by Outblaze
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: cnliou@graffiti.net
Subject: Re: How To Get Bytea Data Instead Of Its Oid
In-Reply-To: <20020919141116.13398.qmail@graffiti.net>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox