The PostgreSQL module also provides a simple interface for running SQL commands on a database and displaying their output. The steps for using it are:
1. | On the main page, click on the icon for the database in which you want to run commands. |
2. | |
3. | Enter any one SQL command into the text box at the top of the page and hit the Execute button. If there was a mistake in your SQL syntax or the command cannot be executed, the error message from PosygreSQL will be displayed. Otherwise, a table of results from SQL (if any) will be shown. Only SELECT statements produce results—UPDATE, INSERT, and other commands that modify records do not. |
Unlike the MySQL module, there is no command history or support for running multiple SQL statements from a file.
3.16.69.106