Physical Structure of Postgres

Postgres is just a directory in your file system.

You can access the directory by $PGDATA.

If you open it, you will find multiple files related to configs.

It also has multiple subdirectories; a few of them are base and global, which are important.

The base subdirectory stores all your databases.

In simple words, the tables you create come under the base subdirectory.