Thread: Counting table/row access

I am using a Postgresql database on a remore server and accessed using ASP.
I have set a table called user_authentication containing user names and
passwords and another column called url.  I have set the ASP login page so
that user name, on login, are directed to the specific URL contained in the
URL column.  I would like to find a way to collect the statistics (number of
accesses) made by each user in the table.  Is this posible and can anyone
tell me how?

Leslie Valmadre
lesliev@oakridgecg.com.au

Leslie,

> I am using a Postgresql database on a remore server and accessed using ASP.
> I have set a table called user_authentication containing user names and
> passwords and another column called url.  I have set the ASP login page so
> that user name, on login, are directed to the specific URL contained in the
> URL column.  I would like to find a way to collect the statistics (number of
> accesses) made by each user in the table.  Is this posible and can anyone
> tell me how?

That depends.  Are the users being logged into the *database* with their own
ids and passwords, or does the application access the database under a
"system user"?

There are a variety of different ways to do this, both in the database and out
of it, and which one you want depends on exactly what information you want to
track.

--
-Josh Berkus
 Aglio Database Solutions
 San Francisco

Hi, I know this is not a plpgsql mail list, but i cant find one, so if
any of you know of one please tell me, or if you ca answer me this
question:

How do i return multiple rows in a plpgsql function? (with example)

thanks

Juan,

> Hi, I know this is not a plpgsql mail list, but i cant find one, so if
> any of you know of one please tell me, or if you ca answer me this
> question:
>
> How do i return multiple rows in a plpgsql function? (with example)

http://techdocs.postgresql.org/guides/SetReturningFunctions

--
-Josh Berkus
 Aglio Database Solutions
 San Francisco