I am trying on windows............ It is not coming.Version is 8.0 ----- Original Message ----- From: "Jeff Frost" <jeff@xxxxxxxxxxxxxxxxxxxxxx> To: "sandhya" <sandhyar@xxxxxxxxxxxxxx> Cc: "Postgres" <pgsql-admin@xxxxxxxxxxxxxx> Sent: Thursday, January 19, 2006 1:00 PM Subject: Re: [ADMIN] Fw: lo_import problem > 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 >