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
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 |