Re: database folder name and tables filenames

From: Mimiko <vbvbrj(at)gmail(dot)com>
To: Postgresql-general <pgsql-general(at)postgresql(dot)org>
Subject: Re: database folder name and tables filenames
Date: 2017-02-14 17:47:00
Message-ID: 7baf68a2-192a-0987-7323-4811ebedc69e@gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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.

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?

--
Mimiko desu.

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Alessandro Baggi 2017-02-14 18:04:09 postgresql how to duplicate rows in result.
Previous Message Magnus Hagander 2017-02-14 17:10:02 Re: PostgreSQL corruption