Re: [GENERAL] psql and blob

2003-09-19 Thread Daniel Schuchardt
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: [G

Re: [GENERAL] psql and blob

2003-09-18 Thread 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

Re: [GENERAL] psql and blob

2003-09-18 Thread Tom Lane
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.

Re: [GENERAL] psql and blob

2003-09-18 Thread Daniel Schuchardt
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 r

Re: [GENERAL] psql and blob

2003-09-18 Thread Daniel Schuchardt
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 clie

Re: [GENERAL] psql and blob

2003-09-18 Thread CoL
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'

Re: [GENERAL] psql and blob

2003-09-17 Thread Jonathan Bartlett
> 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.

Re: [GENERAL] psql and blob

2003-09-17 Thread Nigel J. Andrews
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 \lo_

Re: [GENERAL] psql and blob

2003-09-17 Thread CoL
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 t

Re: [GENERAL] psql and blob

2003-09-17 Thread Daniel Schuchardt
EMAIL 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 ! ---(e

Re: [GENERAL] psql and blob

2003-09-17 Thread Darko Prenosil
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 scr