Re: [GENERAL] database folder name and tables filenames - Mailing list pgsql-general

From Pavel Stehule
Subject Re: [GENERAL] database folder name and tables filenames
Date
Msg-id CAFj8pRB64SrgZ3f9kgCHNu3CmAn8yxsMA2_mAnrYRZx_ziPU8w@mail.gmail.com
Whole thread Raw
In response to Re: [GENERAL] database folder name and tables filenames  (Mimiko <vbvbrj@gmail.com>)
List pgsql-general


2017-02-14 18:47 GMT+01:00 Mimiko <vbvbrj@gmail.com>:
On 14.02.2017 17:30, Adrian Klaver wrote:
Is there a way to change postgres behavior to name database folders by
the database name? And table files in them by table's name? And not
using OIDs.

No.

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.

There are a databases where you can see only one file or few files without any relation to tables.
 



On 14.02.2017 17:34, Tom Lane wrote:
> It used to work like that, decades ago, and it caused enormous problems
> during table/database renames.  We're not going back.

So this is the culprit. Isn't there any option to use names? Even when compiling?

It is not possible.

Regards

Pavel



--
Mimiko desu.



--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

pgsql-general by date:

Previous
From: Alessandro Baggi
Date:
Subject: [GENERAL] postgresql how to duplicate rows in result.
Next
From: Lynn Dobbs
Date:
Subject: Re: [GENERAL] xmlelement AND timestamps.