Return to PostgreSQL

The official FAQs are in the process of being migrated to the wiki. For those not listed on this page, see Official FAQs on the website.

• PostgreSQL General FAQ
• PostgreSQL Developer FAQ

• Running & Installing PostgreSQL On Native Windows

• Why can't I connect to the database from a remote system?
• How do I fix incorrect sequences?
• How can I make a statement faster?
• How do I figure out why some statements are executing slowly?
• What has changed in recent PostgreSQL versions?
• How can admin tasks login to the database without a password?
• Why am I seeing plenty of database writes on my read-only query?
• What GUI database design tools are available?
• What test frameworks exist?
• How do I change the order of columns in a table?
• How can I limit what resources a query or user uses?

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