Am Do, 2003-09-18 um 20.21 schrieb Darko Prenosil:
- Original Message -
From: Daniel Schuchardt [EMAIL PROTECTED]
To: Doug McNaught [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Sent: Thursday, September 18, 2003 4:44 PM
Subject: Re: [GENERAL] psql and blob
Yes thats it.
Ok - one last
hi,
you are right: I wrote it in wrong way. psql is a client program, but he
wants to get the file not from the place where psql runs.
He says:
but i want to execute this script from the client and so my blob-data
is on the client and lo_import fails (the server doesn't have this file).
That's
Yes thats it.
Ok - one last question.
My Script looks like this and actually i can run it only on the server (so i have to
copy all my data to the server each time i want to update my blobs):
INSERT INTO tablexy (BLOBFIELD) VALUES (lo_import('BLOBFILE')).
Now we know if I want to upload a
Yes thats it. Thanks.
Am Mi, 2003-09-17 um 22.42 schrieb Doug McNaught:
Daniel Schuchardt [EMAIL PROTECTED] writes:
Hi @ all,
i'm sure there was a psql-function to transfere my Blob-Data to the
server but I can't remember.
The psql function to use is \lo_import--this reads the file
Daniel Schuchardt [EMAIL PROTECTED] writes:
So I have to do 2 steps manually in psql:
\lo_import(ClientFile) - Returns OID
INSERT INTO tablexy (BLOBFIELD) VALUES (Returned OID)
Is there a way to do this automatically?
See psql's :LASTOID (I think that's the name) variable.
- Original Message -
From: Daniel Schuchardt [EMAIL PROTECTED]
To: Doug McNaught [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Sent: Thursday, September 18, 2003 4:44 PM
Subject: Re: [GENERAL] psql and blob
Yes thats it.
Ok - one last question.
My Script looks like this and actually i can
Hi @ all,
i'm sure there was a psql-function to transfere my Blob-Data to the
server but I can't remember.
I have a script like this :
UPDATE xy SET z = lo_import('localpath_and_file');
but i want to execute this script from the client and so my blob-data is
on the client and lo_import fails
On Wednesday 17 September 2003 18:32, Daniel Schuchardt wrote:
Hi @ all,
i'm sure there was a psql-function to transfere my Blob-Data to the
server but I can't remember.
I have a script like this :
UPDATE xy SET z = lo_import('localpath_and_file');
but i want to execute this script from
PROTECTED]
rg] Im Auftrag von Darko Prenosil
Gesendet: Mittwoch, 17. September 2003 20:07
An: Daniel Schuchardt; [EMAIL PROTECTED]
Betreff: Re: [GENERAL] psql and blob
http://www.postgresql.org/docs/7.3/interactive/largeobjects.html
is what You need.
Regards !
---(end
Hi,
if you, then write a program for that. psql is a database server, not a
client program.
C.
Daniel Schuchardt wrote, On 9/17/2003 8:37 PM:
Hm, but lo_import/lo_export imports/exports from the local filesystem.
I want to upload/download a clientfile to/from the Server Database with
psql. I
Hi @ all,
i'm sure there was a psql-function to transfere my Blob-Data to the
server but I can't remember.
I have a script like this :
UPDATE xy SET z = lo_import('localpath_and_file');
but i want to execute this script from the client and so my blob-data is
on the client and lo_import fails
On Wed, 17 Sep 2003, Daniel Schuchardt wrote:
Hm, but lo_import/lo_export imports/exports from the local filesystem.
I want to upload/download a clientfile to/from the Server Database with
psql. I think this is a feature in psql. But i can't remember...
Yes it is. You want to look up
if you, then write a program for that. psql is a database server, not a
client program.
No, psql is a client program. postmaster is the database server.
Jon
C.
Daniel Schuchardt wrote, On 9/17/2003 8:37 PM:
Hm, but lo_import/lo_export imports/exports from the local filesystem.
I
13 matches
Mail list logo
