Is there anyway to determine when a database was last accessed, or when
a user last connected to the database using the pg_* views? I'm trying
to determine what databases in my system are currently active.
---(end of broadcast)---
TIP 9: In vers
[Please copy the mailing list on replies so others can contribute
to and learn from the discussion.]
On Thu, Sep 01, 2005 at 10:33:44PM -0300, João Carvalho wrote:
> Michael Fuhr <[EMAIL PROTECTED]> escreveu:
> > http://www.postgresql.org/docs/8.0/static/monitoring.html
> > http://www.postgresql.o
On Fri, Sep 02, 2005 at 12:33:00AM +, Joÿffe3o Carvalho wrote:
> I want information about the following statistics:
> -List lock users
> -Show schema owners, it may also so more schema information
> -Check if a certain table has a toast table
See "Monitoring Database Activity" and "Sys
HiIm having problems doing some SQL queries.
I want information about the following statistics:-List lock users-Show schema owners, it may also so more schema information-Check if a certain table has a toast tableIf any one could help that would be very good.Regards_
"Marc G. Fournier" <[EMAIL PROTECTED]> writes:
> all I want to do is:
> CREATE CAST ( 0 AS boolean )
> WITH FUNCTION
> AS ASSIGNMENT;
> And then each time I try to insert a '0' into a BOOLEAN field, it will
> auto convert that (based on my function) to 'f' ...
> And I'd need
Marc G. Fournier wrote:
> Moved off of -hackers, since its long gotten out of that realm :)
>
> On Thu, 1 Sep 2005, Tom Lane wrote:
>
> > "Marc G. Fournier" <[EMAIL PROTECTED]> writes:
> >> On Mon, 29 Aug 2005, Tom Lane wrote:
> >>> No, because there's no built-in cast from smallint to bool.
> >
Moved off of -hackers, since its long gotten out of that realm :)
On Thu, 1 Sep 2005, Tom Lane wrote:
"Marc G. Fournier" <[EMAIL PROTECTED]> writes:
On Mon, 29 Aug 2005, Tom Lane wrote:
No, because there's no built-in cast from smallint to bool.
'k, I just took a read through the "CREATE
