Skip site navigation (1) Skip section navigation (2)

Re: [HACKERS] For review: Server instrumentation patch

From: Andreas Pflug <pgadmin(at)pse-consulting(dot)de>
To: Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
Cc: PostgreSQL-patches <pgsql-patches(at)postgresql(dot)org>
Subject: Re: [HACKERS] For review: Server instrumentation patch
Date: 2005-08-13 15:50:30
Message-ID: 42FE16C6.6040800@pse-consulting.de (view raw or flat)
Thread:
Lists: pgsql-patches
Bruce Momjian wrote:
> 
> Also, do we have a way to return columns from a system-installed
> function?  I really don't like that pg_stat_file() to returns a record
> rather than named columns.  How do I even access the individual record
> values?

As in pg_settings:

SELECT length, mtime FROM pg_file_stat('postgresql.conf') AS st(length 
int4, ctime timestamp, atime timestamp, mtime timestamp, isdir bool)

Regards,
Andreas

In response to

Responses

pgsql-patches by date

Next:From: Tom LaneDate: 2005-08-13 16:11:24
Subject: Re: [HACKERS] For review: Server instrumentation patch
Previous:From: Andreas PflugDate: 2005-08-13 15:43:07
Subject: Re: [HACKERS] For review: Server instrumentation patch

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group