Displays of information about external tables

To display information about external tables, use the \d command from the nzsql prompt.

To list all external tables in the current database, use the \dx command. An example follows:

   dev(admin)=> \dx
     List of relations
   Name     |   Type    | Owner
------------+-----------+-------
extlineitem | ext table | admin
  xlineitem | ext table | admin
(2 rows)

To list the options that are defined in an external table, use the \d<external_tablename> command. An example follows:

   dev(admin)=>\d extlineitem