Database Reference
In-Depth Information
Although I use psql as a scripting tool, I also find it convenient as a query tool. Some people
may find this strange, and assume it is a choice for experts only. Two great features of psql are
the online help for SQL and "tab completion", that allows you to build up SQL quickly without
having to remember the syntax. See the recipe on Using psql and scripting tool for more.
pgAdmin also provides pgAgent, a task scheduler. Again, more portable schedulers are
available, and you may wish to use those instead. Schedulers aren't covered in this topic.
Also, a quick warning: when you create an object in pgAdmin, and if you use capitals anywhere
in the object name, the object will be created with a mixed case name. If I ask for a table
named MyTable, then the only way to access that table is by referring to it in double quotes
as "MyTable". See the recipe about Handling objects with quoted names.
There's more...
phpPgAdmin is available at the following URL:
http://phppgadmin.sourceforge.net/
There is an online demonstration of the software, so you can try it out yourself, and see if it
does the job you want done. The following screenshot shows phpPgAdmin 4 displayed on a
Windows Internet Explorer browser. Version 5 is available and works with PostgreSQL 9.
 
Search WWH ::




Custom Search