X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by postgresql.org (Postfix) with ESMTP id A3C749DD702 for ; Fri, 2 Dec 2005 00:46:00 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 87127-04-3 for ; Fri, 2 Dec 2005 00:45:53 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey- Received: from mars.amiindia.co.in (unknown [203.199.198.229]) by postgresql.org (Postfix) with ESMTP id 79D7F9DD6B6 for ; Fri, 2 Dec 2005 00:45:48 -0400 (AST) Received: from amiindiahjwbgh ([10.0.0.205]) (authenticated bits=0) by mars.amiindia.co.in (8.12.11/8.12.11) with ESMTP id jB24qniL010692; Fri, 2 Dec 2005 10:22:51 +0530 Message-ID: <05e401c5f6fc$2bda85a0$cd00000a@amiindiahjwbgh> From: "sandhya" To: "Guido Barosio" Cc: "postgre" , "sandhya" Subject: reg:File import&export problem Date: Fri, 2 Dec 2005 10:22:17 +0530 MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_NextPart_000_05E1_01C5F72A.455EE060" X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 6.00.2800.1437 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1441 X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=0.001 required=5 tests=[HTML_MESSAGE=0.001] X-Spam-Score: 0.001 X-Spam-Level: X-Archive-Number: 200512/13 X-Sequence-Number: 19733 This is a multi-part message in MIME format. ------=_NextPart_000_05E1_01C5F72A.455EE060 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Hi ....... Pls tell me...how to do this? I have to import and export files from/to a database. Say i have a file named "sample" (assume some path) and i want to store = it in to a database. I did this through lo_import function and i got the object id when i = have used.....the following option. \lo_list ********* QUERY ********** SELECT loid as "ID", pg_catalog.obj_description(loid, 'pg_largeobject') = as "Description" FROM (SELECT DISTINCT loid FROM pg_catalog.pg_largeobject) x ORDER BY "ID" Large objects ID | Description -------+------------- 58782 | 58783 | 58784 | But i want to know whether i can see the contents using this id on the = database side.How can i view this? How to store this(object id) if i want to refer using file name(which we = exported to db) Where can i see the file name in DB?Is there any possible way to store = the names of the file in a database? What i thought is: While importing if there is possibility of storing the file name and = Objid in to a table..and whenever if the user wants to export it from = the db..by giving filename..we need to refer to that table and send the = corresponding OBJID?Am i right Pls tell me how to do this? I need this as early as possible.Help me out in doing this.... Thank you, Sandhya ------=_NextPart_000_05E1_01C5F72A.455EE060 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable
 
Hi = .......
 
Pls tell me...how to do = this?
I have to import and export files = from/to a=20 database.
Say i have a file named "sample" = (assume some path)=20 and i want to store it in to a database.
I did this through lo_import=20 function and i got the object id  when i have used.....the = following option.
 
 \lo_list
********* QUERY=20 **********
SELECT loid as "ID", pg_catalog.obj_description(loid,=20 'pg_largeobject') as "Description"
FROM (SELECT DISTINCT loid FROM=20 pg_catalog.pg_largeobject) x
ORDER BY "ID"   Large=20 objects
  ID   |=20 Description
-------+-------------
 58782 |
 58783=20 |
 58784 |
But i want to know whether i can see = the contents=20 using this id on the database side.How can i view this?
How to store this(object id) if i = want to=20 refer using file name(which we exported to db)
Where can i see the file name in DB?Is = there any=20 possible way to store the names of the file in a database?
 
What i thought is:
While importing if  there is = possibility of=20 storing the file name and Objid in to a table..and whenever if the user = wants to=20 export it from the db..by giving filename..we need to refer to that = table and=20 send the corresponding OBJID?Am i right
 
Pls tell me how to do = this?
I need this as early as possible.Help = me out in=20 doing this....
 
Thank you,
Sandhya
------=_NextPart_000_05E1_01C5F72A.455EE060--