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.gog...@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 > > > >