| From: | Michael Fuhr <mike(at)fuhr(dot)org> |
|---|---|
| To: | Postgres Admin <postgres(at)productivitymedia(dot)com> |
| Cc: | PostgreSQL - Admin <pgsql-admin(at)postgresql(dot)org>, PostgreSQL - PHP <pgsql-php(at)postgresql(dot)org>, PostgreSQL - SQL <pgsql-sql(at)postgresql(dot)org> |
| Subject: | Re: Data insert |
| Date: | 2005-08-20 17:47:53 |
| Message-ID: | 20050820174753.GA68467@winnie.fuhr.org |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin pgsql-php pgsql-sql |
On Sat, Aug 20, 2005 at 01:17:55PM -0400, Postgres Admin wrote:
> I don't have any idea how to insert the type of data into PostgreSQL.
> Basically, it's encrypted data in which I would like that keep raw format.
If the data is binary then you could store it in a BYTEA column. How
to get such data into the database depends on the client interface --
you could escape the data appropriately and embed it into an INSERT
statement, or you could use a parameterized query that either
transfers binary data using the PostgreSQL protocol (available in
7.4 and later) or automatically escapes the data. See your interface
documentation for more information.
--
Michael Fuhr
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Don Drake | 2005-08-21 19:22:25 | sleep? |
| Previous Message | Postgres Admin | 2005-08-20 17:17:55 | Data insert |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Jim C. Nasby | 2005-08-23 00:57:52 | Re: [PHP] Data insert |
| Previous Message | Postgres Admin | 2005-08-20 17:17:55 | Data insert |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Bernard Henry Voynet | 2005-08-20 19:27:15 | Unwanted nested dollar-quoted constants |
| Previous Message | Postgres Admin | 2005-08-20 17:17:55 | Data insert |