Re: [PERFORM] copy command and blobs

2011-02-06 Thread Greg Spiegelberg
On Sat, Jan 22, 2011 at 8:41 PM, Robert Haas robertmh...@gmail.com wrote: On Fri, Jan 21, 2011 at 5:10 PM, Madhu Ramachandran iamma...@gmail.com 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

Re: [PERFORM] copy command and blobs

2011-01-22 Thread Robert Haas
On Fri, Jan 21, 2011 at 5:10 PM, Madhu Ramachandran iamma...@gmail.com 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

Re: [PERFORM] copy command and blobs

2011-01-21 Thread Madhu Ramachandran
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.htmlwhen 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

[PERFORM] copy command and blobs

2011-01-20 Thread Madhu Ramachandran
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

Re: [PERFORM] copy command and blobs

2011-01-20 Thread Mladen Gogala
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

Re: [PERFORM] copy command and blobs

2011-01-20 Thread Tom Lane
Mladen Gogala mladen.gog...@vmsinfo.com 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)..