16.2. Features

Table 16-1 lists the currently available EDB-PSQL+ features:

Table 16-1. EDB-PSQL+ Features

FeatureDescriptionExample(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: w
SELECT * 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+.