Postgres Pro
Downloads
Home   >   mailing lists

Re: copy command and blobs - Mailing list pgsql-performance

From Madhu Ramachandran
Subject Re: copy command and blobs
Date
Msg-id AANLkTi=wENXOtB_wJHY-6VETR2ENv56gTnCVtvVtbASs@mail.gmail.com
Whole thread Raw
In response to Re: copy command and blobs  (Mladen Gogala <mladen.gogala@vmsinfo.com>)
Responses Re: copy command and blobs
List pgsql-performance
Tree view
i was looking at 

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@vmsinfo.com> 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




pgsql-performance by date:

Previous
From: grant@amadensor.com
Date:
Subject: Re: Fun little performance IMPROVEMENT...
Next
From: Robert Haas
Date:
Subject: Re: copy command and blobs