3.23. Launching psql Shells

Administrator enables you to launch a psql shell to the database. From the shell you can make quick changes, including changes that are not possible through Administrator. This quick shell saves you the trouble of having to go to a terminal, type in the hostname, port, user, password, and so on. In order to launch a shell, the Administrator user must have access to psql and xterm.

To launch a shell, right-click on the database to which you want to launch the connection shell and select LAUNCH SHELL (psql).

You can open multiple shells at once and exit them as needed without affecting Administrator.

	Warning
	For security reasons, when you close Administrator you should also close any shell that was launched from Administrator.

	Note
	When launching a shell, Administrator calls xterm and executes psql. This means that the first psql in your path must be correct with respect to the database to which the connection is being launched. For example, if the first psql in the search path is PostgreSQL 7.3 and a connection is being launched to a PostgreSQL 7.1 database, it may not work correctly.