You can turn on logging ... but your transaction would be even slower
after that.
The following links should give you some pointers:
http://www.postgresql.org/docs/8.1/static/monitoring-stats.html
http://www.postgresql.org/docs/8.1/static/monitoring.html
Also try Nagios monitoring plugins for Po
I don't know whether this is a simple one that has been dealt with
before, but if so, I haven't worked out the right question to search on.
If I create a view thus:
create view things as select * from whatever;
and then examine my saved view, I find a list of all of the fields from
whate
I am trying to create a simple function using SQL rather than
PGSQL. At this point, it's just for the exercise.
Is it possible to create a function similar to the following:
create function thing(text) as select * from whatever where id=$1;
Do I need to specify all of the columns from th
Mark Simon wrote:
> create view things as select * from whatever;
>
> and then examine my saved view, I find a list of all of the fields
> from whatever. I thought it should be possible to save the star (*)
> as part of the view. Otherwise, I run into the problem of not getting
> all of the fie