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

---------------------------(end of broadcast)---------------------------
TIP 3: Have you checked our extensive FAQ?

              http://www.postgresql.org/docs/faq

Reply via email to