alviN wrote:
is it possible to execute an sql query to be able to list the tables's
names? well, you can do it on psql using \dt. but im talking about the SQL
statement, because i want to execute that query from a script.
Oh, even *I* know the answer to this one! Run psql with the -E argument
On Wed, 8 Jan 2003, Alan Gutierrez wrote:
alviN wrote:
is it possible to execute an sql query to be able to list the tables's
names? well, you can do it on psql using \dt. but im talking about the SQL
statement, because i want to execute that query from a script.
Oh, even *I* know
I'm making a report in Crystal Reports, which makes use of full join. As Crystal
Reports does not support full join natively, I created a view which contains the join
and based my report on that view. The report has also a parameter to filter only
subset of rows from view. My problem is, that
Tambet Matiisen wrote:
I'm making a report in Crystal Reports, which makes use of full join.
As Crystal Reports does not support full join natively, I created a
view which contains the join and based my report on that view. The
report has also a parameter to filter only subset of rows from
On Tue, 7 Jan 2003, Tom Lane wrote:
Rod Taylor [EMAIL PROTECTED] writes:
I am wondering about a compiler bug, or some other peculiarity on your
platform. Can anyone else using FreeBSD try the above experiment and
see if they get different results from mine on 7.3.* (or CVS tip)?
On
I apologize for having to resort to sending what is most likely a simple
tech support question regarding PostgreSQL to this list but I have not
been able to find the answer in the documentation.
I am responsible for managing a database containing over 6,000 records of
US Forest Service Research
On Wed, Jan 08, 2003 at 09:02:47 -0500,
Randy D. McCracken [EMAIL PROTECTED] wrote:
UPDATE publications SET url = 'www.srs.fs.usda.gov' WHERE url =
'www.srs.fs.fed.us';
For simple cases you can do this with available string functions.
For more complicated cases, you can write a simple
I'm confused. How do I massage the integer 10102 into the date
2002-01-01?
cmi= select to_date('010102','MMDDYY');
to_date
2002-01-01
(1 row)
cmi= select to_char(10102,'00');
to_char
-
010102
(1 row)
cmi= select to_date(to_char(10102,'00'),'MMDDYY');
On Wed, Jan 08, 2003 at 08:49:00 -0600,
Richard Rowell [EMAIL PROTECTED] wrote:
I'm confused. How do I massage the integer 10102 into the date
2002-01-01?
cmi= select to_char(10102,'00');
to_char
-
010102
(1 row)
Note the leading space in the returned row. That is
REPLACE is the right function for you avaliable as an addon.
install it in postgresql installation using the source at:
http://www.brasileiro.net:8080/postgres/cookbook/view-one-recipe.adp?recipe_id=23
if you face problem please lemme know
once this function is installed you could update
Hi
I have trouble executing count(*)
statement.
On a large dataset it takes quite a while to return
result.
Is there any other way to get number of tupples in
relation
or is the only way tooptimize count()
function to indexit?
thanks
Nikola
On Wed, Jan 08, 2003 at 17:04:40 +0100,
Nikola Ivacic [EMAIL PROTECTED] wrote:
Hi
I have trouble executing count(*) statement.
On a large dataset it takes quite a while to return result.
Is there any other way to get number of tupples in relation
or is the only way to optimize count()
The problem is in other software I use,
witch uses count(*) function to display relation properties
pgAdmin II
phpPgAdmin
Nikola
- Original Message -
From: Bruno Wolff III [EMAIL PROTECTED]
To: Nikola Ivacic [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Sent: Wednesday, January 08, 2003 5:22
On Wed, Jan 08, 2003 at 09:02:47AM -0500, Randy D. McCracken wrote:
I apologize for having to resort to sending what is most likely a simple
tech support question regarding PostgreSQL to this list but I have not
been able to find the answer in the documentation.
Hey, this is Open Source:
Hi,
I could not find much documentation about SQL 92 schemas that version
7.3 now supports. I understood it was a structure to group various
objects, which allows faster privilege management, namespaces
definition.
Besides that, I don't see any advantages. I'd be glad if someone could
point them
I am not sure pgAdmin uses count(*) and I didn't have time to check
phpPgAdmin also, I presumed it from similarly slow response I get in psql
Nikola
- Original Message -
From: Ian Harding [EMAIL PROTECTED]
To: [EMAIL PROTECTED]; [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Sent: Wednesday,
Bob Lapique wrote:
Hi,
I could not find much documentation about SQL 92 schemas that version
7.3 now supports. I understood it was a structure to group various
objects, which allows faster privilege management, namespaces
definition.
Besides that, I don't see any advantages. I'd be glad if
Just to close off the thread, here is the end-result of investigating
Achilleus Mantzios' problem.
--- Forwarded Message
Date:Wed, 08 Jan 2003 11:54:36 -0500
From:Tom Lane [EMAIL PROTECTED]
To: Achilleus Mantzios [EMAIL PROTECTED]
Subject: Re: [SQL] [PERFORM] 7.3.1 index use /
Nikola,
I am not sure pgAdmin uses count(*) and I didn't have time to check
phpPgAdmin also, I presumed it from similarly slow response I get in
psql
Well, pgAdmin and phpPgAdmin have their own mailing lists. I'd suggest
posting there. Ideally, these programs should have an option that
On Tue, Jan 07, 2003 at 11:01:08AM -0500, Tom Lane wrote:
I thought that the idea behind noup was to protect single columns from
update. However, when I apply the noup trigger as above, I can't
update /any/ column. Is this the intended behaviour?
Idly looking at the source code for
Just to close off another thread and to give a tad more information...
I was not clear enough in my initial question to the list because not all
of the URLs I am trying to change begin with http://www.srs.fs.fed.us/ so
what I was really looking for was the syntax for replacing
www.srs.fs.fed.us
I could not find much documentation about SQL 92 schemas that
7.3 now supports. I understood it was a structure to group various
objects, which allows faster privilege management, namespaces
definition.
Besides that, I don't see any advantages. I'd be glad if someone
could point them
chester c young wrote:
I could not find much documentation about SQL 92 schemas that
7.3 now supports. I understood it was a structure to group various
objects, which allows faster privilege management, namespaces
definition.
Besides that, I don't see any advantages. I'd be glad if
Is there a bugzilla kind of thing for Postgresql?
I would like to help out on the development, but have no idea where to
start...
Thanks
Wei
---(end of broadcast)---
TIP 5: Have you checked our extensive FAQ?
No bugzilla, but do have a TODO list. See the developers FAQ.
---
Wei Weng wrote:
Is there a bugzilla kind of thing for Postgresql?
I would like to help out on the development, but have no idea where to
start...
any anyone explain whats wrong with the replace based solution to this problem
which i posted earlier?
did i misunderstood anything?
regds
mallah.
On Thursday 09 January 2003 01:48 am, Randy D. McCracken wrote:
Just to close off another thread and to give a tad more information...
I was
26 matches
Mail list logo