Hi,
is there a detailed discription of postgresql functions which I get with
\df. Or a detailed document about them.
thanks...
Murat
>
> Hi,
>
> is there a detailed discription of postgresql functions which I get with
> \df. Or a detailed document about them.
What more info do you need? Maybe the documenation in docs?
--
Bruce Momjian| http://www.op.net/~candle
[EMAIL PROTECTED]|
Some detailed discription, some examples, bu at least the list of them. I
can't put the output of \df command to a file.
Murat
On Fri, 8 Jan 1999, Bruce Momjian wrote:
> >
> > Hi,
> >
> > is there a detailed discription of postgresql functions which I get with
> > \df. Or a detailed docum
> I can't put the output of \df command to a file.
psql -d database -c "\df" > file
>
> Some detailed discription, some examples, bu at least the list of them. I
> can't put the output of \df command to a file.
Try:
echo "\\df" | psql test >file
There is a short one-line description of each one. Do you need more?
--
Bruce Momjian| http
Hello,
My programm uses postgres every minute, thats why i keep connection
to postgres all the time my programm live. When the programm just started
postmaster gets about one meg. But in few days after
the postmaster process grow up to 15 Mb in memory, thow my databases
are small enough (approx
Try:
select current_date, CURRENT_DATE - INTERVAL '1 DAY';
?column?|?column?
--+--
1999-01-08|1999-01-07 00:00:00+01
(1 row)
PostgreSQL has a syntax sligth different than SQL92. You have to enclose
'1 DAY' instead of '1' DAY.
-Jose'-
Kevin Heflin wrote:
>
> Tryi
On Fri, 8 Jan 1999, Jose' Soares wrote:
> Try:
>
> select current_date, CURRENT_DATE - INTERVAL '1 DAY';
> ?column?|?column?
> --+--
> 1999-01-08|1999-01-07 00:00:00+01
> (1 row)
>
> PostgreSQL has a syntax sligth different than SQL92. You have to enclose
> '1 DAY
Hi,
I'm using Postgre in my Java program.
The Java bean (JCDatasource from KL group)
require callable statement when saving to
the DB. But Postgre report Callable statement
is not supported.
Anybody knows if 6.4 support callable statement?
Or anyother ways to work around?
Thank you very much.
The Hermit Hacker <[EMAIL PROTECTED]> writes:
> On Wed, 6 Jan 1999, Silvio Emanuel Barbosa de Macedo wrote:
>
> >
> > Hi!
> >
> > Where can I find the required patch to upgrade 6.4.1 to 6.4.2 ?
>
> There is no patch for this...we've tried in the past to create "clean"
> patches, and each time
I wrote a c func (ATTACHED BELOW) which takes 2 pointers to type text, and
a bool field. When a field in a row passed to the func is null, espically
the 'first' field, Postgresql does not return the value that my code
produced.
For example:
First lastco nocompany
---
Please forgive my newbieness but I am extremely new to both Postgresql AND
Linux. I've been a consultant for 6 years working mostly on Microsoft
platforms (NT, MSSQL). I have developed many data-driven websites using
WinNT/IIS/ASP/MSSQL. Now, getting sick of MS and being enamored with the
whole Op
Very observant of you. The postgres function system doesn't have a way
to tell which parameter is null, so the function just returns null.
I don't like it and we hope to get it changed for PGv6.5 (at least I
do).
Is it on the TODO guys? Jan, do you think you'll have the time to get
to it by bet
There has been a discussion in the HACKERS list (check the archives on
the website
[http:\\www.postgresql.org\]) about PostgreSQL vs MS SQL 6.5 for the
last 2 days or so.
I think these ideas must come in threes, so where is that other person?
I can't really give a feature comparison of MS SQL 7
On Fri, 8 Jan 1999, Sze Yuen Wong wrote:
> Hi,
>
> I'm using Postgre in my Java program.
> The Java bean (JCDatasource from KL group)
> require callable statement when saving to
> the DB. But Postgre report Callable statement
> is not supported.
> Anybody knows if 6.4 support callable statemen
15 matches
Mail list logo