Re: [PERFORM] copy command and blobs

On Sat, Jan 22, 2011 at 8:41 PM, Robert Haas wrote: > On Fri, Jan 21, 2011 at 5:10 PM, Madhu Ramachandran > wrote: > > 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 > > f

Re: [PERFORM] copy command and blobs

On Fri, Jan 21, 2011 at 5:10 PM, Madhu Ramachandran wrote: > 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 ) It's probably worth noting that that document is 9 years o

Re: [PERFORM] copy command and blobs

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 wro

Re: [PERFORM] copy command and blobs

Mladen Gogala writes: > Madhu Ramachandran wrote: >> 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 keyw

Re: [PERFORM] copy command and blobs

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 generate

[PERFORM] copy command and blobs

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).. I tried giving the path to the file, lo_import('pathto file').. appreciate an