agora inbox for pgsql-sql@postgresql.org  

help / color / mirror / Atom feed

From: Adrian Chong <achong@cecid.hku.hk>
To: Christoph Haller <ch@rodos.fzk.de>
To: pgsql-sql@postgresql.org
Subject: Re: bytea
Date: Wed, 5 Feb 2003 18:25:01 +0800
Message-ID: <016d01c2cd00$d7a2a5d0$20b10893@achongpc> (raw)
References: <3E40E45A.6D20C6EE@rodos.fzk.de>

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@rodos.fzk.de>
To: <pgsql-sql@postgresql.org>
Cc: <achong@cecid.hku.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@postgresql.org so that your
> message can get through to the mailing list cleanly
>

view thread (17+ messages)  latest in thread

Message-ID: <016d01c2cd00$d7a2a5d0$20b10893@achongpc>
Permalink:  ../016d01c2cd00$d7a2a5d0$20b10893@achongpc/
Also on:    postgresql.org/message-id/016d01c2cd00$d7a2a5d0$20b10893@achongpc

reply

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: achong@cecid.hku.hk, ch@rodos.fzk.de
  Subject: Re: bytea
  In-Reply-To: <016d01c2cd00$d7a2a5d0$20b10893@achongpc>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox