Thread: 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
Attachment
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