Peter Wang wrote:
> The BYTEA data look like "/031/024/001/003?/022/".
> How can I use some PostgreSQL function to remove "/" when I use
> select statement ? What type of format is the BYTEA datatype? Can I
> output it to hexadecimal or octal format ? If you can, how ? Or do
> you know any thir
I output the BYTEA datatype for a table in our database.
The BYTEA data look like "/031/024/001/003?/022/".
How can I use some PostgreSQL function to remove "/" when I use select statement ?
What type of format is the BYTEA datatype? Can I output it to hexadecimal or octal
format ? If you ca
beyaNet Consultancy wrote:
Hi,
what I am trying to do is to be able to store images in my database.
What I wanted to know is this:
1. Would it be better to have the image field type as a bytea or a blob?
I have heard it mentioned that bytea would be better as doing data dumps
would also insure
On Tuesday 09 March 2004 18:33, you wrote:
> Hi. If it wouldn't be too much of a bother could you send me sample code
> that used SQL commands to insert a bytea as well as retrieve, that includes
> the encode / decode stuff? I have been struggling to figure out how to get
> this to work. I am us
On Wednesday 18 February 2004 09:18, you wrote:
> Maybe if bandwidth is a restriction the base64 solution
> saves some bandwith, since base64 file is ~ 1.3 times larger
> than the original, whereas the escaped octal representation
> will be ~ 4 times larger.
If you use libpq's v3 protocol with bin
On Wednesday 18 February 2004 15:17, Dana Hudes wrote:
> How can one measure the result of the compression -- can I see this in
> some table or with some pgsql command?
Hmm - not so far as I know.
> At what threshold does it take place, I think its 8192?
> The nasty bit is not one picture of 100k
How can one measure the result of the compression -- can I see this in
some table or with some pgsql command?
At what threshold does it take place, I think its 8192?
The nasty bit is not one picture of 100kb.
Its 20 pictures of 5kb.
On Wed, 18 Feb 2004, Richard Huxton wrote:
> On Wednesday 18 Feb
On Wednesday 18 February 2004 06:44, Dana Hudes wrote:
>
> At least with base64 I have ample libraries and can convert my data
> before sending to sql or after receiving from sql. It becomes my
> application's issue. Mind, this bloats the data considerably.
> escape is less bloat but I have to recr
Generally this is the task of various drivers.
The postgresql jdbc for instance makes this task
easy with the ResultSet.getBytes() method.
The servlet code to display the contents of any mimetype
bytea column looks like:
PreparedStatement st =
con.prepareStatement("select mimetype,image from im
On Tuesday 17 February 2004 18:08, you wrote:
> I'd recommend to let the application convert the binary
> data to and from base64,
Don't, please don't !
Since you have the good bytea rule to convert so called "binary" data into so
called "text". You have no need another encoding at all.
Genera
PROTECTED] Behalf Of Jan Wieck
Sent: Tuesday, February 17, 2004 10:08 AM
To: beyaNet Consultancy
Cc: [EMAIL PROTECTED]
Subject: Re: [SQL] bytea or blobs?
beyaNet Consultancy wrote:
Hi,
what I am trying to do is to be able to store images in my database.
What I wanted to know is this:
1. Would it be
in the database that
I'm missing?
Thanks,
Jeremy
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] Behalf Of Jan Wieck
Sent: Tuesday, February 17, 2004 10:08 AM
To: beyaNet Consultancy
Cc: [EMAIL PROTECTED]
Subject: Re: [SQL] bytea or blobs?
beyaNet Consultancy wr
beyaNet Consultancy wrote:
Hi,
what I am trying to do is to be able to store images in my database.
What I wanted to know is this:
1. Would it be better to have the image field type as a bytea or a
blob? I have heard it mentioned that bytea would be better as doing
data dumps would also insure
I'm in the same situation. I struggled with it for days
considering various implementation issues for my application
and what I hoped to achieve. I opted to use bytea but getting the
data in and out is going to be interesting . have to use encode/decode.
However I don't have to worry about making t
Hi,
what I am trying to do is to be able to store images in my database.
What I wanted to know is this:
1. Would it be better to have the image field type as a bytea or a
blob? I have heard it mentioned that bytea would be better as doing
data dumps would also insure that the image was saved as
do is loading a file of a
> particular path with a sql statement in psql. Why I need to care about how
> the file looks like? Thanks.
>
> Adrian
>
> - Original Message -
> From: "Christoph Haller" <[EMAIL PROTECTED]>
> To: <[EMAIL PROTECTED]>
>
> Thanks for your reply. But what I want to do is loading a file of a
particular path with a sql
> statement in psql. Why I need to care about how the file looks like?
Thanks.
>
Because "non-printables" might not be properly escaped.
If they are, just use the SQL COPY command as described in the
MAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Wednesday, February 05, 2003 6:15 PM
Subject: Re: [SQL] bytea
> >
> > I have a table containing a field of type bytea:
> >
> > CREATE TABLE a_table (
> > a_field bytea
> > );
> >
> >
>
> I have a table containing a field of type bytea:
>
> CREATE TABLE a_table (
> a_field bytea
> );
>
> How can I import a file in a SQL script? What function I can use?
>
The documentation says as in PostgreSQL 7.2.1 (I doubt this changed
significantly since)
Octets of certain values must be
Hello,
I have a table containing a field of type bytea:
CREATE TABLE a_table (
a_field bytea
);
How can I import a file in a SQL script? What function I can use?
Thank you very much.
Adrian
---(end of broadcast)---
TIP 4: Don't 'kill -9' the
Hi , All!
Could someone clarify me :
When I want to store BLOB's internally in database
(for example jpeg )
should I use bytea or OID? Is OID something like
BFILE in Oracle 8i?
If both are appropriate why I can't
use
update image set picture=lo_import('Myfile') where
image_code='blablab
Hi , All!
Could someone clarify me :
When I want to store BLOB's internally in database (for example jpeg )
should I use bytea or OID? Is OID something like BFILE in Oracle 8i?
If both are appropriate for internal BLOB why I can't use
update image set picture=lo_import('Myfile') where imag
22 matches
Mail list logo
