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

Re: binary bytea

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: David Kitzinger ARA/SWD <David(dot)Kitzinger(at)ara(dot)com>
Cc: pgsql-novice(at)postgresql(dot)org
Subject: Re: binary bytea
Date: 2004-04-10 03:15:35
Message-ID: 1741.1081566935@sss.pgh.pa.us (view raw or flat)
Thread:
Lists: pgsql-novice
David Kitzinger ARA/SWD <David(dot)Kitzinger(at)ara(dot)com> writes:
> I'm confused. I have a bytea column that should be binary format
> (right?), yet PQfformat() says it is NOT binary

The column datatype has nothing to do with whether the data is presented
in binary or textual format.  The way you determine that is by making a
query in the right way.  See for instance the resultFormat parameter of
PQexecParams.

			regards, tom lane

In response to

  • binary bytea at 2004-04-07 22:45:05 from David Kitzinger ARA/SWD

pgsql-novice by date

Next:From: M. BastinDate: 2004-04-10 09:28:09
Subject: Re: binary bytea
Previous:From: Tom LaneDate: 2004-04-09 05:39:05
Subject: Re: Usage: pg_dump's text format

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