Re: bytea

Hi Christoph,

Thanks for your reply. But what I want to do is loading a file of a particular path with a sql
statement in psql. Why I need to care about how the file looks like? Thanks.

Adrian

----- Original Message -----
From: "Christoph Haller" <ch(at)rodos(dot)fzk(dot)de>
To: <pgsql-sql(at)postgresql(dot)org>
Cc: <achong(at)cecid(dot)hku(dot)hk>
Sent: Wednesday, February 05, 2003 6:15 PM
Subject: Re: [SQL] bytea

> >
> > I have a table containing a field of type bytea:
> >
> > CREATE TABLE a_table (
> > a_field bytea
> > );
> >
> > How can I import a file in a SQL script? What function I can use?
> >
> The documentation says as in PostgreSQL 7.2.1 (I doubt this changed
> significantly since)
>
> Octets of certain values must be escaped (but all octet values may be
> escaped) when used as part of a string literal in an SQL
> statement. In general, to escape an octet, it is converted into the
> three-digit octal number equivalent of its decimal octet value, and
> preceded by two backslashes.
>
> In general it goes like this
> INSERT INTO a_table ( a_field ) VALUES ( '\\000\\001\\002\\003' ) ;
> to load the first four ASCII characters.
> You did not mention how your file looks like.
> There is also a C function available called PQescapeBytea
> which does all the required escaping to store memory areas in bytea
> columns.
> Refer to Command Execution Functions within libpq - C Library for
> details.
>
> Regards, Christoph
>
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 3: if posting/reading through Usenet, please send an appropriate
> subscribe-nomail command to majordomo(at)postgresql(dot)org so that your
> message can get through to the mailing list cleanly
>