pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedReg: File import&export problem
3+ messages / 2 participants
[nested] [flat]
* Reg: File import&export problem
@ 2005-12-01 10:36 sandhya <sandhyar@amiindia.co.in>
0 siblings, 1 reply; 3+ messages in thread
From: sandhya @ 2005-12-01 10:36 UTC (permalink / raw)
To: pgsql-admin; +Cc: sandhya <sandhyar@amiindia.co.in>
Hi...
Please help me in sorting out the below problem.
While doing importing and expoting files(This is first time i am using this concept)..i got the following error message.
Anything i have to include?
How to rectify it?
pls tell me to proceed further.......
: undefined reference to `lo_creat'
/tmp/ccYefhjF.o(.text+0x87): In function `importFile':
: undefined reference to `lo_open'
/tmp/ccYefhjF.o(.text+0xd3): In function `importFile':
: undefined reference to `lo_write'
/tmp/ccYefhjF.o(.text+0x121): In function `importFile':
: undefined reference to `lo_close'
/tmp/ccYefhjF.o(.text+0x145): In function `exportFile':
: undefined reference to `lo_open'
/tmp/ccYefhjF.o(.text+0x1bf): In function `exportFile':
: undefined reference to `lo_read'
/tmp/ccYefhjF.o(.text+0x22e): In function `exportFile':
: undefined reference to `lo_close'
/tmp/ccYefhjF.o(.text+0x255): In function `exit_nicely':
: undefined reference to `PQfinish'
/tmp/ccYefhjF.o(.text+0x2d5): In function `main':
: undefined reference to `PQsetdbLogin'
/tmp/ccYefhjF.o(.text+0x2e6): In function `main':
: undefined reference to `PQstatus'
/tmp/ccYefhjF.o(.text+0x315): In function `main':
: undefined reference to `PQerrorMessage'
/tmp/ccYefhjF.o(.text+0x34a): In function `main':
: undefined reference to `PQexec'
/tmp/ccYefhjF.o(.text+0x35b): In function `main':
: undefined reference to `PQclear'
/tmp/ccYefhjF.o(.text+0x37f): In function `main':
: undefined reference to `lo_import'
/tmp/ccYefhjF.o(.text+0x3a9): In function `main':
: undefined reference to `lo_export'
/tmp/ccYefhjF.o(.text+0x3bc): In function `main':
: undefined reference to `PQexec'
thanks,
Sandhya
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: Reg: File import&export problem
@ 2005-12-01 22:44 Guido Barosio <gbarosio@gmail.com>
parent: sandhya <sandhyar@amiindia.co.in>
0 siblings, 0 replies; 3+ messages in thread
From: Guido Barosio @ 2005-12-01 22:44 UTC (permalink / raw)
To: sandhya <sandhyar@amiindia.co.in>; +Cc: pgsql-admin
Hi Sandhya
Your request, again, seems to be poor in terms of information to the mailing
list.
I would sugest you to write this mail again, including the command's being
run, and describing the idea behind them. That would be a good start :)
Best wishes,
Guido
On 12/1/05, sandhya <sandhyar@amiindia.co.in> wrote:
>
> Hi...
> Please help me in sorting out the below problem.
> While doing importing and expoting files(This is first time i am using
> this concept)..i got the following error message.
> Anything i have to include?
> How to rectify it?
> pls tell me to proceed further.......
>
>
> : undefined reference to `lo_creat'
> /tmp/ccYefhjF.o(.text+0x87): In function `importFile':
> : undefined reference to `lo_open'
> /tmp/ccYefhjF.o(.text+0xd3): In function `importFile':
> : undefined reference to `lo_write'
> /tmp/ccYefhjF.o(.text+0x121): In function `importFile':
> : undefined reference to `lo_close'
> /tmp/ccYefhjF.o(.text+0x145): In function `exportFile':
> : undefined reference to `lo_open'
> /tmp/ccYefhjF.o(.text+0x1bf): In function `exportFile':
> : undefined reference to `lo_read'
> /tmp/ccYefhjF.o(.text+0x22e): In function `exportFile':
> : undefined reference to `lo_close'
> /tmp/ccYefhjF.o(.text+0x255): In function `exit_nicely':
> : undefined reference to `PQfinish'
> /tmp/ccYefhjF.o(.text+0x2d5): In function `main':
> : undefined reference to `PQsetdbLogin'
> /tmp/ccYefhjF.o(.text+0x2e6): In function `main':
> : undefined reference to `PQstatus'
> /tmp/ccYefhjF.o(.text+0x315): In function `main':
> : undefined reference to `PQerrorMessage'
> /tmp/ccYefhjF.o(.text+0x34a): In function `main':
> : undefined reference to `PQexec'
> /tmp/ccYefhjF.o(.text+0x35b): In function `main':
> : undefined reference to `PQclear'
> /tmp/ccYefhjF.o(.text+0x37f): In function `main':
> : undefined reference to `lo_import'
> /tmp/ccYefhjF.o(.text+0x3a9): In function `main':
> : undefined reference to `lo_export'
> /tmp/ccYefhjF.o(.text+0x3bc): In function `main':
> : undefined reference to `PQexec'
> thanks,
> Sandhya
>
--
"Adopting the position that you are smarter than an automatic
optimization algorithm is generally a good way to achieve less
performance, not more" - Tom Lane.
^ permalink raw reply [nested|flat] 3+ messages in thread
* reg:File import&export problem
@ 2005-12-02 04:52 sandhya <sandhyar@amiindia.co.in>
0 siblings, 0 replies; 3+ messages in thread
From: sandhya @ 2005-12-02 04:52 UTC (permalink / raw)
To: Guido Barosio <gbarosio@gmail.com>; +Cc: pgsql-admin; sandhya <sandhyar@amiindia.co.in>
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
^ permalink raw reply [nested|flat] 3+ messages in thread
end of thread, other threads:[~2005-12-02 04:52 UTC | newest]
Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2005-12-01 10:36 Reg: File import&export problem sandhya <sandhyar@amiindia.co.in>
2005-12-01 22:44 ` Guido Barosio <gbarosio@gmail.com>
2005-12-02 04:52 reg:File import&export problem sandhya <sandhyar@amiindia.co.in>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox