> Hi everyone, I have to insert a few PDF files into my database, and I
> am not able to do it ...
> I have to use PHP3, and all I could do was use the lo_import, but in
> this case, I am not able to insert any data because I am not an
> administrator. Is there any other way of doing it, using,
One quick and dirty way could be to create symbolic links from files in
pgsql/data/base to an equivalent folder on your respective disks.
On Tue, 13 Jun 2000, Byron Joseph Bacaltos wrote:
> Sir,
>
> I am currently using ingres and would like to migrate to postgres.
> However the problem is that
Andrea Aime wrote:
>
> Hi people. I'm writing a client application in Visual Basic,
> and I need to lock certain records (a read lock) for
> a long period of time (well, from the start just to
> the stop of my application) so that no one can modify
> them. I've seen a lock command, but it seem on
Hi,
I am currently trying to sell the usefulness of PostgreSQL to my company (A consulting
firm). I need a couple convincing arguments. One thing that I was unable to find good
comparisons of is performance of PostgreSQL vs. Others (Oracle, SQL Server, Sybase).
Does anyone have any benchmarks
Mike Salib wrote:
>
> Hi,
> I'm trying to find out if I can store more than 8k characters of data in
> one field in a single row. I'm working on a web based app and limiting
> myself to 8k posts is problematic. Has this limitation changed in
> Postgres 7?
No. You have three options, I think.
(
If you're only consideration is raw performance of lookups on text
fields, I suppose there might be some measureable performance advantage
in putting everything in one table, but I doubt you'd really notice the
difference. If you *did* do this, what is the significance of the
authorID field?
Nor
Daniel Mendyke wrote:
>
> MySQL allows me to use DATE_FORMAT( col_name, '%D %M %Y' )
> to format the data. What function or method does Postgres
> provide for formating timestamp data?
Try to_char( timestamp_col_name, 'DD MM ' ).
See the section on "Formatting Functions" in the distributio
Hi people. I'm writing a client application in Visual Basic,
and I need to lock certain records (a read lock) for
a long period of time (well, from the start just to
the stop of my application) so that no one can modify
them. I've seen a lock command, but it seem only capable
to lock an entire tab
>From psql:
test => \o
test =>
test => \o
This will leave the results of your query in the file "output-file-name"
This IS covered in the documentation and from within psql with \h
len morgan
-Original Message-
From: [EMAIL PROTECTED] <[EMAIL PROTECTED]>
To: NEERAJ BANSAL <[EMAIL PR
Chapter 10 of Bruce's book has a really good discussion
of locking and all that.(I was reading it yesterday.) The book is at
http://www.postgresql.org/docs/aw_pgsql_book/
Barnes
-Original Message-From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]]On Behalf Of
T.J.FarrellS
>
> Does anyone knows how do you send query output to a file???
Welcome to Unix(TM):
psql -c "select * from , etc." >
See also:
http://www.isu.edu/departments/comcom/unix/workshop/io.html
or, type "unix tutorial" in any web search engine.
--Gene
> I tried following but it does not work:
> Sir,
>
> I am currently using ingres and would like to migrate to postgres.
> However the problem is that my existing database is now over 2GB and all of
> my scsi disks are only at 2GB. In ingres all I have to do to extend large
> tables to multiple locations or file systems (disks) there
12 matches
Mail list logo
