hello everybody,
i have only a short question
can someone tell me which filename extenion postgresql database has?
thank you very much!
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.