This is what works for me from the command line on Linux with PG 8.0.3:
INSERT into images VALUES ( lo_import('/tmp/white.jpg'), 'white');
What version of postgresql are you using?
On Thu, 19 Jan 2006, sandhya wrote:
When i am using lo_import to load files into the database i am getting the following error.....
Please help me what i need to do
Insert into sampletbl values(lo_import('c:\\sample.txt'),'sample.txt');
ERROR: function lo_import ("unknown") does not exist
HINT: No function matches the given name and argument types. You may need to ad
d explicit type casts.
--
Jeff Frost, Owner <jeff@xxxxxxxxxxxxxxxxxxxxxx>
Frost Consulting, LLC http://www.frostconsultingllc.com/
Phone: 650-780-7908 FAX: 650-649-1954
