ok...jeff thank you very much.
I checked in pg_hba.conf and reloaded again and did now working fine.
- Original Message -
From: "Jeff Frost" <[EMAIL PROTECTED]>
To: "sandhya" <[EMAIL PROTECTED]>
Cc: "Postgres"
Sent: Thursday, January 19, 2006
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
I am trying on windows..I am getting the following error message.
ERROR: could not open server file
- Original Message -
From: "Jeff Frost" <[EMAIL PROTECTED]>
To: "sandhya" <[EMAIL PROTECTED]>
Cc: "Postgres"
Sent: Thursday, January 19, 2006
I am trying on windows
It is not coming.Version is 8.0
- Original Message -
From: "Jeff Frost" <[EMAIL PROTECTED]>
To: "sandhya" <[EMAIL PROTECTED]>
Cc: "Postgres"
Sent: Thursday, January 19, 2006 1:00 PM
Subject: Re: [ADMIN] Fw: lo
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 th
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
existHINT: No function matches the g
