Re: copy command and blobs

[Madhu Ramachandran <iammadhu@xxxxxxxxx>]

i was looking at

http://www.postgresql.org/files/documentation/books/aw_pgsql/node96.html

when they talk about using OID type to store large blobs (in my case .jpg files )

On Thu, Jan 20, 2011 at 3:17 PM, Mladen Gogala <mladen.gogala@xxxxxxxxxxx> wrote:

Madhu Ramachandran wrote:

hello,

i have a table with OID column.. I want to use the copy command to insert bunch of rows (1 million).
but iam unable to specify the correct format for the oid type (i have .jpg files to be stored in this column)..

Huh? oid is a keyword, an automatically generated row id, and is deprecated. You shouldn't be doing anything with it, much less copying it.


--

Mladen Gogala Sr. Oracle DBA
1500 Broadway
New York, NY 10036
(212) 329-5251
http://www.vmsinfo.com The Leader in Integrated Media Intelligence Solutions