reg:File import&export problem - Mailing list pgsql-admin

From sandhya
Subject reg:File import&export problem
Date
Msg-id 05e401c5f6fc$2bda85a0$cd00000a@amiindiahjwbgh
Whole thread Raw
List pgsql-admin
 
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

pgsql-admin by date:

Previous
From: Jeff Frost
Date:
Subject: Input on certification requirements
Next
From: "sandhya"
Date:
Subject: help pls