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
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
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
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
