Where is the saved database?

Hi all,
I am puzzeld how the file system works. Where are databases, tables,
functions etc, created using psql, stored? In which format/ extension?

Can we view these files with a normal editor such as Kate?

Regards,
Setyo Nugroho