Postgresql Faq (CloudMonk.io)

PostgreSQL FAQ

Return to PostgreSQL

Official FAQs

The official FAQs are in the process of being migrated to the wiki. For those not listed on this page, see [http://www.postgresql.org/docs/faq/ Official FAQs on the website].

General FAQs

* PostgreSQL General FAQ
* PostgreSQL Developer FAQ

Platform FAQs

* Running & Installing PostgreSQL On Native Windows

Other FAQs

* PostgreSQL Client Authentication|Why can't I connect to the database from a remote system?
* PostgreSQL Fixing Sequences|How do I fix incorrect sequences?
* PostgreSQL Using EXPLAIN|How can I make a statement faster?
* PostgreSQL Logging Difficult Queries|How do I figure out why some statements are executing slowly?
* PostgreSQL Version History|What has changed in recent PostgreSQL versions?
* PostgreSQL pgpass|How can admin tasks login to the database without a password?
* PostgreSQL Hint Bits|Why am I seeing plenty of database writes on my read-only query?
* PostgreSQL GUI Database Design Tools|What GUI database design tools are available?
* PostgreSQL Test Frameworks|What test frameworks exist?
* PostgreSQL Alter column position|How do I change the order of columns in a table?
* PostgreSQL Priorities|How can I limit what resources a query or user uses?

Asking questions

Please read the PostgreSQL Guide to reporting problems before posting a question not answered in the FAQ. You're more likely to get a better answer, sooner.

Fair Use Source: https://wiki.postgresql.org/wiki/Frequently_Asked_Questions