Posted by Rex in PostgreSQL PgSQL
From the PostgreSQL psql monitor, use the following command to view the tables in the current database:
\dt
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 ... 
Show or list tables in a MySQL databaseOnce you have selected a database, you can list the tables in it by using the show command. To view all of the tables in the selected database, use: ... 
Display the Structure of PostgreSQL/PgSQL Table FieldsFrom within the psql monitor, issue the following command to view the structure of the table named 'elephants': \d elephants
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 ... 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 ... 
Show or list tables in a MySQL databaseOnce you have selected a database, you can list the tables in it by using the show command. To view all of the tables ... 
May 24, 2010 at 10:45 am, noMan said:
very old post
September 09, 2010 at 9:03 pm, Joe said:
So what? Still worked for me…
August 13, 2010 at 7:17 am, Marek Pe said:
You can receive column comments in SQL:
SELECT a.attname AS column, d.description AS COMMENT
FROM pg_class c
JOIN pg_description d ON c.oid=d.objoid
JOIN pg_attribute a ON c.oid = a.attrelid
WHERE c.relname=’monitors’
AND a.attnum = d.objsubid
December 08, 2010 at 7:07 pm, Guest said:
select
ordinal_position,
column_name,
data_type,
is_nullable,
description.description as comment
from
information_schema.columns columns
left join pg_class class on (columns.table_name = class.relname)
left join pg_description description on (class.oid = description.objoid)
left join pg_attribute attrib on (class.oid = attrib.attrelid and columns.column_name = attrib.attname and attrib.attnum = description.objsubid)
where
table_name=’{$tableName}’
group by
ordinal_position, column_name, data_type, is_nullable, description.description
July 13, 2011 at 6:46 pm, runa said:
Thanks
It worked
September 14, 2011 at 2:39 pm, Taller de creación literaria cinco letras said:
not working :s
September 14, 2011 at 2:43 pm, Taller de creación literaria cinco letras said:
Never mind, I did´t selected the db