The directory "base" contains filenames(numbers) that correspond to the
oid of the postgreSQL databases. Those databases have subdirectories
that contain the filenames(numbers) that correspond to the oid of objects
(sequences, tables, etc) in those databases.
You may find the attached queries help
On Mon, 2017-11-27 at 15:19 +, Martin Mueller wrote:
> Apologies if I asked this question before.
> Is this normal behavior?
Yes.
> Where in the postgres documentation do I read up on this?
Start here - https://www.postgresql.org/docs/10/static/admin.html
> string functions and regular
Hi,
I think you need to read this:
https://www.postgresql.org/docs/current/static/storage-file-layout.html
On 11/27/2017 04:19 PM, Martin Mueller wrote:
> Apologies if I asked this question before.
>
> I’m a newcomer to Postgres, having migrated from Mysql. Information
> about tables seems har
Apologies if I asked this question before.
I’m a newcomer to Postgres, having migrated from Mysql. Information about
tables seems harder to get at in Postgres. That data directory on my machine is
suspiciously large—well over 100 GB. The directory Postgres/var-9.5/base/
contains a number of
