This worked fine for me on a freshly installed 8.0.3 on Windows XP:
pics=# INSERT into images VALUES ( lo_import('C:\\Program Files\\PostgreSQL\\8.0\\Installation Notes.rtf'), 'notes');
"could not open server file" means that either the file does not exist, or the
user you are trying to access the file as does not have the rights to read it.
Again, check your permissions as I mentioned to you earlier.
On Wed, 18 Jan 2006, Jeff Frost wrote:
> 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