filename extension postgreSQL

Originally Posted by Aussifan74

hello everybody,

i have only a short question
can someone tell me which filename extenion postgresql database has?
thank you very much!

Originally Posted by adamitj

Hello there!

Unfortunally, PgSQL does not use a simple file to store schema and data. It uses a lot of files located at the same directory of the initialization cluster defined by the PGDATA environment variable. Each database has one directory, and its name is a incremental number, the same as all objects within a PgSQL database (a view, a table, a domain, etc). These numbers are called OID (Object IDentificator).

If you want to migrate to another server, you must backup it before. The same for backups.