Обсуждение: Data insert

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

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

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