Hello,
To save pdf files into postgresql8.3, what is the best column type?
bytea, blob, etc?
Thank you,
Emi
--
Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-sql
I have the following tables (individual seat allocation removed to make it
simpler)
create table coaches ( -- carriages
c_id serial primary key,
c_namevarchar(20) not null
);
create table trains ( -- one for each train
t_id serial primary key
);
create table train_coaches
Hello,
Postgresql8.3, tried:
create table test(id, image oid);
insert into test values(1, lo_import('apple.jpg'));
ERROR: must be superuser to use server-side lo_import()
HINT: Anyone can use the client-side lo_import() provided by libpq.
About client-side lo_import(), is there an online do
Unless you've good reasons to do so it's best to store the file on the
file system and the file name/path in the database ...
On 05/18/2011 22:20, Emi Lu wrote:
Hello,
To save pdf files into postgresql8.3, what is the best column type?
bytea, blob, etc?
Thank you,
Emi
<>
--
Sent via pgsq
On Wed, May 18, 2011 at 10:46:23PM +0200, Julien Cigar wrote:
> Unless you've good reasons to do so it's best to store the file on
> the file system
Why ?
If you suggest reasons are needed for storing the PDF in the
database I'd like to know the reasons for *not* doing so.
Karsten
--
GPG key I
On 05/18/2011 23:00, Karsten Hilbert wrote:
On Wed, May 18, 2011 at 10:46:23PM +0200, Julien Cigar wrote:
Unless you've good reasons to do so it's best to store the file on
the file system
Why ?
If you suggest reasons are needed for storing the PDF in the
database I'd like to know the reasons
On Wed, May 18, 2011 at 11:21:43PM +0200, Julien Cigar wrote:
> >>Unless you've good reasons to do so it's best to store the file on
> >>the file system
> >Why ?
> >
> >If you suggest reasons are needed for storing the PDF in the
> >database I'd like to know the reasons for *not* doing so.
>
> It
On 05/18/2011 23:27, Karsten Hilbert wrote:
On Wed, May 18, 2011 at 11:21:43PM +0200, Julien Cigar wrote:
Unless you've good reasons to do so it's best to store the file on
the file system
Why ?
If you suggest reasons are needed for storing the PDF in the
database I'd like to know the reasons
Is there anywhere that gives you all the available collations and their
definitions? I found with the C collation it now sorts the spaces
correct but it is also case sensitive which messes with some of our
other sorts.
-Original Message-
From: Tom Lane [mailto:t...@sss.pgh.pa.us]
Sent: T
On Wed, May 18, 2011 at 2:20 PM, Emi Lu wrote:
> Hello,
>
> To save pdf files into postgresql8.3, what is the best column type?
>
> bytea, blob, etc?
>
> Thank you,
> Emi
>
Everyone else has pointed out reasons for not doing this, and I agree with
them that in the large majority of cases just st
On Wed, 18 May 2011 20:10:19 +0100, Gary Stainburn wrote about [SQL]
foreign keys and lots of tables:
>I have the following tables (individual seat allocation removed to
>make it simpler)
Omitting details makes the problem more difficult to comprehend.
[snip]
>create table booking_seats (
> b_i
On 05/19/2011 04:51 AM, Emi Lu wrote:
About client-side lo_import(), is there an online doc about install
lo_import?
It's in the manual.
http://www.postgresql.org/docs/current/static/lo-examplesect.html
--
Craig Ringer
--
Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org)
To make ch
On 05/19/2011 05:21 AM, Julien Cigar wrote:
On 05/18/2011 23:00, Karsten Hilbert wrote:
On Wed, May 18, 2011 at 10:46:23PM +0200, Julien Cigar wrote:
Unless you've good reasons to do so it's best to store the file on
the file system
Why ?
If you suggest reasons are needed for storing the PDF
Right!
The external binary file storage has another advantage (that may be
considered as disadvantage as well) - it is usually easier to develop
and test mechanism as you're able to browse uploaded file result using
os / application or even "exchange" file contents for test purposes,
while in
14 matches
Mail list logo
