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@frostconsultingllc.com>
Frost Consulting, LLC http://www.frostconsultingllc.com/
Phone: 650-780-7908 FAX: 650-649-1954