Re: database folder name and tables filenames

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Mimiko <vbvbrj(at)gmail(dot)com>
Cc: Postgresql-general <pgsql-general(at)postgresql(dot)org>
Subject: Re: database folder name and tables filenames
Date: 2017-02-14 19:23:49
Message-ID: 22292.1487100229@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Joshua D. Drake 2017-02-14 19:31:21 Re: Can't restart Postgres
Previous Message Shawn Thomas 2017-02-14 19:17:27 Can't restart Postgres