Table 16-1 lists the currently available EDB-PSQL+ features:
Table 16-1. EDB-PSQL+ Features
| Feature | Description | Example(s) |
|---|---|---|
| Launch EDB-PSQL+ from the command line. |
Allow a user to launch EDB-PSQL+ and connect to a specific database by giving
valid credentials and database name, it's usage is described below:
edb-psql dbname userid
| edb-psql edb enterprisedb --Connect to the edb database as user enterprisedb |
| DESC or DESCRIBE for getting the definition of database objects. | The EDB-PSQL+ DESCRIBE/DESC command returns the definitions of tables and views in a particular database. | For example to view the definition of our sample "dept" table, you would do something as follows:
edb=# DESCRIBE dept;
Table "public.dept"
Column | Type | Modifiers
--------+--------------+-----------
deptno | numeric(2,0) | not null
dname | varchar2(14) |
loc | varchar2(13) |
Indexes:
"dept_pk" PRIMARY KEY
"dept_dname_uq" UNIQUE
|
| L for query listing | Support for L command which enables listing last query in the buffer in EDB-PSQL+. | Suppose we run the following query, and then subsequently use L, it would list the last query as shown below:
edb=# SELECT * FROM emp edb-# WHERE deptno = 10; empno | ename | job | mgr | hiredate | sal | comm | deptno -------+--------+-----------+------+-----------+---------+------+-------- 7782 | CLARK | MANAGER | 7839 | 09-jun-81 | 2450.00 | | 10 7839 | KING | PRESIDENT | | 17-nov-81 | 5000.00 | | 10 7934 | MILLER | CLERK | 7782 | 23-jan-82 | 1300.00 | | 10 (3 rows) edb=# L SELECT * FROM emp WHERE deptno = 10; |
| R for query listing and execution | Support for R command in EDB-PSQL+ for listing and executing the last query in the buffer. | Suppose we ran the following query previously in EDB-PSQL+, then used R, it would re run the query as shown below:
wSELECT * FROM emp WHERE deptno = 10; edb=# R empno | ename | job | mgr | hiredate | sal | comm | deptno -------+--------+-----------+------+-----------+---------+------+-------- 7782 | CLARK | MANAGER | 7839 | 09-jun-81 | 2450.00 | | 10 7839 | KING | PRESIDENT | | 17-nov-81 | 5000.00 | | 10 7934 | MILLER | CLERK | 7782 | 23-jan-82 | 1300.00 | | 10 (3 rows) |
| Exit or Quit to terminate EDB-PSQL+ | Allow the use of exit or quit command to terminate a EDB-PSQL+ session. | The following example exists from EDB-PSQL+ and takes you back to your normal shell/command prompt.
edb=# exit
[sarah@isb-sarah work]#
|
Please refer to edb-psql for further details on EDB-PSQL+.