pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedregarding image files in DB
5+ messages / 2 participants
[nested] [flat]
* regarding image files in DB
@ 2006-05-11 05:18 sandhya <sandhyar@amiindia.co.in>
0 siblings, 1 reply; 5+ messages in thread
From: sandhya @ 2006-05-11 05:18 UTC (permalink / raw)
To: pgsql-admin; +Cc: sandhya <sandhyar@amiindia.co.in>
Hi,
Please explain me is there any difference if i load my files(like gif or any images files) into the data base as text format?
Bcoz,I have loaded my image files in a text format into the database and when i exported it into my local file system the content of the original file(i.e. imported file into DB) and the exported file from the DB are different.
What is the wrong i did?In which format i have to load my file.Is it only for image files or for all types of files(like js,asp,htm etc)
Please help me in resolving this issue.
Thanks in advance
Regards,
Sandhya
^ permalink raw reply [nested|flat] 5+ messages in thread
* Regarding image files in DB
@ 2006-05-11 07:12 sandhya <sandhyar@amiindia.co.in>
0 siblings, 0 replies; 5+ messages in thread
From: sandhya @ 2006-05-11 07:12 UTC (permalink / raw)
To: pgsql-admin
Hi,
Please explain me is there any difference if i load my files(like gif or any images files) into the data base as text format?
Bcoz,I have loaded my image files in a text format into the database and when i exported it into my local file system the content of the original file(i.e. imported file into DB) and the exported file from the DB are different.
What is the wrong i did?In which format i have to load my file.Is it only for image files or for all types of files(like js,asp,htm etc)
I installed postgresql8.0 ..
Please help me in resolving this issue.
Thanks in advance
Regards,
Sandhya
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: regarding image files in DB
@ 2006-05-11 07:26 Andy Shellam <andy.shellam@mailnetwork.co.uk>
parent: sandhya <sandhyar@amiindia.co.in>
0 siblings, 0 replies; 5+ messages in thread
From: Andy Shellam @ 2006-05-11 07:26 UTC (permalink / raw)
To: 'sandhya' <sandhyar@amiindia.co.in>; +Cc: pgsql-admin
I would think a data type with the likes of "binary" (bytea?) would be more
appropriate. It's like trying to upload an image via FTP in ASCII format -
it never comes out the same the other end.
_____
From: pgsql-admin-owner@postgresql.org
[mailto:pgsql-admin-owner@postgresql.org] On Behalf Of sandhya
Sent: 11 May 2006 6:19 am
To: Postgres
Cc: sandhya
Subject: [ADMIN] regarding image files in DB
Hi,
Please explain me is there any difference if i load my files(like gif or
any images files) into the data base as text format?
Bcoz,I have loaded my image files in a text format into the database and
when i exported it into my local file system the content of the original
file(i.e. imported file into DB) and the exported file from the DB are
different.
What is the wrong i did?In which format i have to load my file.Is it only
for image files or for all types of files(like js,asp,htm etc)
Please help me in resolving this issue.
Thanks in advance
Regards,
Sandhya
!DSPAM:14,4462c7c434491454781929!
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: regarding image files in DB
@ 2006-05-11 07:44 sandhya <sandhyar@amiindia.co.in>
1 sibling, 0 replies; 5+ messages in thread
From: sandhya @ 2006-05-11 07:44 UTC (permalink / raw)
To: andy.shellam@mailnetwork.co.uk; +Cc: pgsql-admin
hi ...
It's like trying to upload an image via FTP in ASCII format - it never comes out the same the other end.
Which one you are referring ?You mean
If i load files using lo_import into DB and when i export it and see the content is different right!!!
But i read in postgres document as bytea is only for small files and not ot store large contents.Am i right?
I have already a table which stores all my image files as OID format?Is there any alternative to do?
Whether i need to store only image files in bytea format or all files like(js,asp,htm etc) also....
Please explain me..It is very much needed for me..
Thank you,
sandhya
----- Original Message -----
From: Andy Shellam
To: 'sandhya'
Cc: pgsql-admin@postgresql.org
Sent: Thursday, May 11, 2006 12:56 PM
Subject: RE: [ADMIN] regarding image files in DB
I would think a data type with the likes of "binary" (bytea?) would be more appropriate. It's like trying to upload an image via FTP in ASCII format - it never comes out the same the other end.
------------------------------------------------------------------------------
From: pgsql-admin-owner@postgresql.org [mailto:pgsql-admin-owner@postgresql.org] On Behalf Of sandhya
Sent: 11 May 2006 6:19 am
To: Postgres
Cc: sandhya
Subject: [ADMIN] regarding image files in DB
Hi,
Please explain me is there any difference if i load my files(like gif or any images files) into the data base as text format?
Bcoz,I have loaded my image files in a text format into the database and when i exported it into my local file system the content of the original file(i.e. imported file into DB) and the exported file from the DB are different.
What is the wrong i did?In which format i have to load my file.Is it only for image files or for all types of files(like js,asp,htm etc)
Please help me in resolving this issue.
Thanks in advance
Regards,
Sandhya
!DSPAM:14,4462c7c434491454781929!
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: regarding image files in DB
@ 2006-05-11 07:45 sandhya <sandhyar@amiindia.co.in>
1 sibling, 0 replies; 5+ messages in thread
From: sandhya @ 2006-05-11 07:45 UTC (permalink / raw)
To: andy.shellam@mailnetwork.co.uk; +Cc: pgsql-admin
Is there any document which explains clarly about how to load files in binart format and how to retrieve it....As far as i read i got only files storing in OID format.
Thanks for your help...
Sandhya
----- Original Message -----
From: Andy Shellam
To: 'sandhya'
Cc: pgsql-admin@postgresql.org
Sent: Thursday, May 11, 2006 12:56 PM
Subject: RE: [ADMIN] regarding image files in DB
I would think a data type with the likes of "binary" (bytea?) would be more appropriate. It's like trying to upload an image via FTP in ASCII format - it never comes out the same the other end.
------------------------------------------------------------------------------
From: pgsql-admin-owner@postgresql.org [mailto:pgsql-admin-owner@postgresql.org] On Behalf Of sandhya
Sent: 11 May 2006 6:19 am
To: Postgres
Cc: sandhya
Subject: [ADMIN] regarding image files in DB
Hi,
Please explain me is there any difference if i load my files(like gif or any images files) into the data base as text format?
Bcoz,I have loaded my image files in a text format into the database and when i exported it into my local file system the content of the original file(i.e. imported file into DB) and the exported file from the DB are different.
What is the wrong i did?In which format i have to load my file.Is it only for image files or for all types of files(like js,asp,htm etc)
Please help me in resolving this issue.
Thanks in advance
Regards,
Sandhya
!DSPAM:14,4462c7c434491454781929!
^ permalink raw reply [nested|flat] 5+ messages in thread
end of thread, other threads:[~2006-05-11 07:45 UTC | newest]
Thread overview: 5+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2006-05-11 05:18 regarding image files in DB sandhya <sandhyar@amiindia.co.in>
2006-05-11 07:26 ` Andy Shellam <andy.shellam@mailnetwork.co.uk>
2006-05-11 07:12 Regarding image files in DB sandhya <sandhyar@amiindia.co.in>
2006-05-11 07:44 ` sandhya <sandhyar@amiindia.co.in>
2006-05-11 07:45 ` 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