By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,963 Members | 1,260 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,963 IT Pros & Developers. It's quick & easy.

filename extension postgreSQL

P: 2
hello everybody,

i have only a short question
can someone tell me which filename extenion postgresql database has?
thank you very much!
Oct 19 '06 #1
Share this Question
Share on Google+
2 Replies


P: 1
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.
Oct 24 '06 #2

P: 2
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.

Hello!
Thank you very much!
Oct 25 '06 #3

Post your reply

Sign in to post your reply or Sign up for a free account.