Re: [GENERAL] database folder name and tables filenames

2017-02-14 Thread Adrian Klaver
On 02/14/2017 09:47 AM, Mimiko wrote: > 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

Re: [GENERAL] database folder name and tables filenames

2017-02-14 Thread Tom Lane
Mimiko 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, li

Re: [GENERAL] database folder name and tables filenames

2017-02-14 Thread Pavel Stehule
2017-02-14 18:47 GMT+01:00 Mimiko : > 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

Re: [GENERAL] database folder name and tables filenames

2017-02-14 Thread Mimiko
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 conven

Re: [GENERAL] database folder name and tables filenames

2017-02-14 Thread Adrian Klaver
On 02/14/2017 07:19 AM, Mimiko wrote: Hello. 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? -- Adrian Klaver adrian.kla...

Re: [GENERAL] database folder name and tables filenames

2017-02-14 Thread Adrian Klaver
On 02/14/2017 07:19 AM, Mimiko wrote: Hello. 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. For more information see: https://www.postgresql.org/docs/9.6/static/storage-file-layout.html

Re: [GENERAL] database folder name and tables filenames

2017-02-14 Thread Tom Lane
Mimiko writes: > 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. It used to work like that, decades ago, and it caused enormous problems during table/database renames. We're not going back.

[GENERAL] database folder name and tables filenames

2017-02-14 Thread Mimiko
Hello. 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. -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/ma