Mimiko <vbvbrj(at)gmail(dot)com> writes:
> On 14.02.2017 17:30, Adrian Klaver wrote:
>> Is there a particular problem you are trying to solve?
> No, there is not a problem. Its a convenience to visually view databases and tables with theirs name and know what the size they occupy with using
> queries of pg_catalog, like there is in mysql.
Don't really see why you need the underlying files to be named differently
for that purpose. Typically people write something like
select relname, pg_relation_size(oid) from pg_class where ...
If you really want to do it from outside the database, the
contrib/oid2name program might help you.
regards, tom lane