| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| 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 19:23:49 |
| Message-ID: | 22292.1487100229@sss.pgh.pa.us |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Mimiko <vbvbrj(at)gmail(dot)com> 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, like there is in mysql.
Don't really see why you need the underlying files to be named differently
for that purpose. Typically people write something like
select relname, pg_relation_size(oid) from pg_class where ...
If you really want to do it from outside the database, the
contrib/oid2name program might help you.
regards, tom lane
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Joshua D. Drake | 2017-02-14 19:31:21 | Re: Can't restart Postgres |
| Previous Message | Shawn Thomas | 2017-02-14 19:17:27 | Can't restart Postgres |