Posted by Rex in PostgreSQL PgSQL
From within the psql monitor, issue the following command to view the structure of the table named ‘elephants’:
\d elephants
Follow the reactions below and share your own thoughts.
List the Databases on a PostgreSQL/PgSQL ServerFrom within the psql monitor, use the following command to list all of the databases in the server: \l Alternatively, you can list the databases from the command line ... 
Display or show tables in a PostgreSQL/PgSQL databaseFrom the PostgreSQL psql monitor, use the following command to view the tables in the current database: \dt
Display PostgreSQL/PgSQL versionTo display the PostgreSQL version number (and other information like compiler version used to build PgSQL) issue the following SQL statement from within psql: SELECT version(); To quickly determine ... 
Describe the column structure of a MySQL tableThe SQL command 'describe' allows you to view the column structure of a MySQL table. It provides a listing of the columns of a table, the type of each ... 
List the Databases on a PostgreSQL/PgSQL ServerFrom within the psql monitor, use the following command to list all of the databases in the server: \l Alternatively, you can list the ... 
Display or show tables in a PostgreSQL/PgSQL databaseFrom the PostgreSQL psql monitor, use the following command to view the tables in the current database: \dt
September 09, 2010 at 6:50 am, Jassi Paramjit said:
Thanks Sir, I really need this coomand