| Lists: | pgsql-adminpgsql-phppgsql-sql |
|---|
| From: | Postgres Admin <postgres(at)productivitymedia(dot)com> |
|---|---|
| To: | 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: | Data insert |
| Date: | 2005-08-20 17:17:55 |
| Message-ID: | 430765C3.9090309@productivitymedia.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Lists: | pgsql-admin pgsql-php pgsql-sql |
Sorry for the attachment, but copying and pasting this data does not work.
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.
Thanks for any help,
J
| Attachment | Content-Type | Size |
|---|---|---|
| sample_data.pdf | application/pdf | 6.5 KB |
| 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: | Raw Message | Whole Thread | Download mbox | Resend email |
| 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: | "Jim C(dot) Nasby" <jnasby(at)pervasive(dot)com> |
|---|---|
| To: | Aldor <an(at)mediaroot(dot)de> |
| Cc: | Postgres Admin <postgres(at)productivitymedia(dot)com>, 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: [PHP] Data insert |
| Date: | 2005-08-23 00:57:52 |
| Message-ID: | 20050823005752.GI17203@pervasive.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Lists: | pgsql-admin pgsql-php pgsql-sql |
On Sun, Aug 21, 2005 at 06:35:22AM +0100, Aldor wrote:
> if you want to insert biiig data volumes try either using COPY instead
> of INSERT - it will run much much faster
And if for some reason you have to stick with inserts, group them into
transactions; it will perform much better than individual transactions.
--
Jim C. Nasby, Sr. Engineering Consultant jnasby(at)pervasive(dot)com
Pervasive Software http://pervasive.com 512-569-9461