FW: How to store binaries and ASCII files in DB

Hi,

is their any php code example on how to store files (binary and ASCII) into=
a postgres db?

Thanks,
Matthias





---------------------------(end of broadcast)---------------------------
TIP 8: explain analyze is your friend

Re: FW: How to store binaries and ASCII files in DB

Hi,

On 6/15/05, Weber Matthias wrote:
> is their any php code example on how to store files (binary and
> ASCII) into a postgres db?

There's not so much difference between a data INSERT and file storage.
But, as a first step, you should decide on the way you want to store
the related data. Will it be stored on a normal table row (in a bytea
field) or as a large object? If you'll use LO, then you should refer
to its documentation for related functions and examples. But if you'll
use a normal bytea column, I'd strongly encourage you to use
parameters while inserting data. This is going to save you from CPU
and RAM wasting escaping routines, plus SQL-Injection attacks. (For
further performance tweaks, you can use binary mode while transmitting
data.)

Regards.

---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster

Re: FW: How to store binaries and ASCII files in DB

On Wed, Jun 15, 2005 at 12:42:28PM +0200, Weber Matthias wrote:
> is their any php code example on how to store files (binary and ASCII) =
into a postgres db?
http://www.php.net/manual/en/function.file-get-contents.php
http://www.php.net/manual/en/function.pg-escape-bytea.php
http://www.php.net/manual/en/function.pg-escape-string.php
http://www.php.net/manual/en/function.pg-query.php


p.
--=20
Pawe=B3 Bernat; uselessness' lover;
select''as email;
Slowly and surely the unix crept up on the Nintendo user ...

---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?

http://www.postgresql.org/docs/faq