reg:File import&export problem

From: "sandhya" <sandhyar(at)amiindia(dot)co(dot)in>
To: "Guido Barosio" <gbarosio(at)gmail(dot)com>
Cc: "postgre" <pgsql-admin(at)postgresql(dot)org>, "sandhya" <sandhyar(at)amiindia(dot)co(dot)in>
Subject: reg:File import&export problem
Date: 2005-12-02 04:52:17
Message-ID: 05e401c5f6fc$2bda85a0$cd00000a@amiindiahjwbgh
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Browse pgsql-admin by date

  From Date Subject
Next Message sandhya 2005-12-02 06:59:42 help pls
Previous Message Jeff Frost 2005-12-02 03:57:01 Input on certification requirements