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
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
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 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 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
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 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
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: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 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
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
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
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,
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
14 matches
Mail list logo
