Re: copy command and blobs

i was looking at
http://www.postgresql.org/files/documentation/books/aw_pgsql/node96.html

<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(dot)gogala(at)vmsinfo(dot)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
>
>
>
>