psql is probably the most favored client tool to work with PostgreSQL, and pgAdmin is the popular GUI tool. We will cover a couple of basic features of pgAdmin and also have a look at a few not-so-basic features. To cover the tool exhaustively with screenshots, it will consume many pages and probably not add much value. There are other options such as phpPgAdmin and TOra, (toolkit for Oracle, but supports many databases) which you could explore.
PostgreSQL for Data Architects
By :
PostgreSQL for Data Architects
By:
Overview of this book
Table of Contents (19 chapters)
PostgreSQL for Data Architects
Credits
About the Author
About the Reviewers
www.PacktPub.com
Preface
Free Chapter
Installing PostgreSQL
Server Architecture
PostgreSQL – Object Hierarchy and Roles
Working with Transactions
Data Modeling with SQL Power Architect
Client Tools
SQL Tuning
Server Tuning
Tools to Move Data in and out of PostgreSQL
Scaling, Replication, and Backup and Recovery
PostgreSQL – Troubleshooting
PostgreSQL – Extras
Index
Customer Reviews