Re: [SQL] How To Get Bytea Data Instead Of Its Oid

2002-09-19 Thread Tom Lane
"CN LIOU" <[EMAIL PROTECTED]> writes: > SELECT * FROM test LIMIT 1 > returns, I guess, the OID of c2 instead of the binary data to which the OID points. I don't think so... regression=# create table test (c1 text,c2 bytea); CREATE TABLE regression=# insert into test values ('some text', 'some b

[SQL] How To Get Bytea Data Instead Of Its Oid

2002-09-19 Thread CN LIOU
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