list files and sizes

Поиск
Список
Период
Сортировка
От richard@xentu.com
Тема list files and sizes
Дата
Msg-id c3a5ff17680fd129b7465550c5362269@xentu.com
обсуждение исходный текст
Ответы Re: list files and sizes
Re: list files and sizes
Список pgsql-novice
Could anyone tell me if this is possible?

I can get a list of files from the pg_log directory using

select * from pg_ls_dir('pg_log')

For any one of those files, I could find out it's size using

select * from pg_stat_file('pg_log\postgresql-2016-02-16_133214.log')

but, what I'd like to have is a query that somehow combines those two
and returns a recordset consisting of two columns, file_name & file_size

I could probably write procedural code to do this, but am thinking it
maybe can be done, somehow, in a single statement.


В списке pgsql-novice по дате отправления:

Предыдущее
От: Killian Driscoll
Дата:
Сообщение: Re: Create view that retrieves both table and column comments
Следующее
От: Joe Conway
Дата:
Сообщение: Re: list files and sizes