pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedData insert
3+ messages / 3 participants
[nested] [flat]
* Data insert
@ 2005-08-20 17:17 Postgres Admin <postgres@productivitymedia.com>
2005-08-20 17:47 ` Re: Data insert Michael Fuhr <mike@fuhr.org>
2005-08-23 00:57 ` Re: [PHP] Data insert Jim C. Nasby <jnasby@pervasive.com>
0 siblings, 2 replies; 3+ messages in thread
From: Postgres Admin @ 2005-08-20 17:17 UTC (permalink / raw)
To: pgsql-admin; PostgreSQL - PHP <pgsql-php@postgresql.org>; PostgreSQL - SQL <pgsql-sql@postgresql.org>
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
Attachments:
[application/pdf] sample_data.pdf (6.5K, ../../430765C3.9090309@productivitymedia.com/2-sample_data.pdf)
download
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: Data insert
2005-08-20 17:17 Data insert Postgres Admin <postgres@productivitymedia.com>
@ 2005-08-20 17:47 ` Michael Fuhr <mike@fuhr.org>
1 sibling, 0 replies; 3+ messages in thread
From: Michael Fuhr @ 2005-08-20 17:47 UTC (permalink / raw)
To: Postgres Admin <postgres@productivitymedia.com>; +Cc: pgsql-admin; PostgreSQL - PHP <pgsql-php@postgresql.org>; PostgreSQL - SQL <pgsql-sql@postgresql.org>
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
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: [PHP] Data insert
2005-08-20 17:17 Data insert Postgres Admin <postgres@productivitymedia.com>
@ 2005-08-23 00:57 ` Jim C. Nasby <jnasby@pervasive.com>
1 sibling, 0 replies; 3+ messages in thread
From: Jim C. Nasby @ 2005-08-23 00:57 UTC (permalink / raw)
To: Aldor <an@mediaroot.de>; +Cc: Postgres Admin <postgres@productivitymedia.com>; pgsql-admin; PostgreSQL - PHP <pgsql-php@postgresql.org>; PostgreSQL - SQL <pgsql-sql@postgresql.org>
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@pervasive.com
Pervasive Software http://pervasive.com 512-569-9461
^ permalink raw reply [nested|flat] 3+ messages in thread
end of thread, other threads:[~2005-08-23 00:57 UTC | newest]
Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2005-08-20 17:17 Data insert Postgres Admin <postgres@productivitymedia.com>
2005-08-20 17:47 ` Michael Fuhr <mike@fuhr.org>
2005-08-23 00:57 ` Jim C. Nasby <jnasby@pervasive.com>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox