Re: database folder name and tables filenames

2017-02-14 18:47 GMT+01:00 Mimiko <vbvbrj(at)gmail(dot)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(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general
>