From: | Pavel Stehule <pavel(dot)stehule(at)gmail(dot)com> |
---|---|
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 18:06:21 |
Message-ID: | CAFj8pRB64SrgZ3f9kgCHNu3CmAn8yxsMA2_mAnrYRZx_ziPU8w@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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
>
From | Date | Subject | |
---|---|---|---|
Next Message | Lynn Dobbs | 2017-02-14 18:12:07 | Re: xmlelement AND timestamps. |
Previous Message | Alessandro Baggi | 2017-02-14 18:04:09 | postgresql how to duplicate rows in result. |