On Wed, Mar 21, 2007 at 02:37:07PM -0300, Ezequias R. da Rocha wrote:
> Great I am thinking of putting my like to rest. I felt it faster than
> "like" statement, have you any information about that ?
I think this rather depends on what you're doing.
If you're searching for "like 'blahblah%' or "
> How will I enable command string to see the commands?
in your postgresql.conf set stats_command_string = true
read
http://www.postgresql.org/docs/8.2/interactive/monitoring-stats.html for
details
---(end of broadcast)---
TIP 3: Have you checked
George,
How will I enable command string to see the commands?
Regards
skarthi
From: "George Pavlov" <[EMAIL PROTECTED]>
To: "Karthikeyan Sundaram"
<[EMAIL PROTECTED]>,,
Subject: Re: [SQL] Monitor what command is executing at the backend
Date: Wed, 21 Mar 2007 14:56:50 -0700
>Is there
>Is there a way to see from the log files on what sql statement is
> currently by which user? In other words, I want to monitor
> the DB activity.
for a current snapshot you don't need the logs, try:
select * from pg_stat_activity;
(command string needs to be enabled for your database.)
Hi everybody,
Is there a way to see from the log files on what sql statement is
currently by which user? In other words, I want to monitor the DB activity.
How can I find it?
Regards
skarthi
_
Get a FREE Web site, company
On Wed, 2007-03-21 at 14:37 -0300, Ezequias R. da Rocha wrote:
> Guy Fraser escreveu:
> > On Wed, 2007-03-21 at 11:04 -0300, Ezequias R. da Rocha wrote:
> >
> >> Hi list,
> >>
> >> I would like to know if postgresql has a Regular Expressions (Regex)
> >> implemented already.
> >>
> >> With it w
Guy Fraser escreveu:
On Wed, 2007-03-21 at 11:04 -0300, Ezequias R. da Rocha wrote:
Hi list,
I would like to know if postgresql has a Regular Expressions (Regex)
implemented already.
With it we could implement queries like
Select * from myClientes where name = 'E[zs]equias'
Case S
Hi,
Our database is growing fast. I want to create a cronjob that should
tell me what is the current size of the database on each day.
How can I find this from the database? Is there any pre-written scripts
written by somebody to share?
Regards
skarthi
_
Hi,
I think I had the exact same problem as you do a while back and I
solved it by removing the header row and the "CSV HEADER" clause of the
statement. For the large files I had, it was easier (for me) to remove
the header row than it was to escape out all the quotes (or regen the
file):
C
I recognize the value of working with people who love what they do, that is why
I am looking into the open source community. I am a statistician so I have no
idea about how to find OSS programmers. Any suggestions are welcomed.
A quantitative hedge fund within Lazard Asset Management in New Yor
Is anybody still using the ability to set sql_inheritance to OFF?
I'm considering removing the parameter in PG 8.3, so that the current
default behavior (sql_inheritance = ON) would be the only behavior.
sql_inheritance was created in 7.1 to allow existing applications to
not be broken when we chan
On Wed, 2007-03-21 at 11:04 -0300, Ezequias R. da Rocha wrote:
> Hi list,
>
> I would like to know if postgresql has a Regular Expressions (Regex)
> implemented already.
>
> With it we could implement queries like
>
> Select * from myClientes where name = 'E[zs]equias'
>
Case Sensitive Regular
Ezequias R. da Rocha wrote:
Hi list,
I would like to know if postgresql has a Regular Expressions (Regex)
implemented already.
With it we could implement queries like
Select * from myClientes where name = 'E[zs]equias'
where the result occurs even if the field has Ezequias or Esequias.
Reg
Hi list,
I would like to know if postgresql has a Regular Expressions (Regex)
implemented already.
With it we could implement queries like
Select * from myClientes where name = 'E[zs]equias'
where the result occurs even if the field has Ezequias or Esequias.
Regards
Ezequias
--
14 matches
Mail list logo
