Show Tables

To list all tables in the public schema of the database...

psql database

\d

To describe a specific table...

\d tablename

To show schemas...

\dn

To describe a table using information_schema...

SELECT table_name, 

       column_name, 

       data_type 

  FROM information_schema.columns

 WHERE table_name = 'mytable';

CREATE TABLE

Unless you want your table to be in the "public" schema, you should create a schema and create your table in it. For example...

CREATE SCHEMA myschema;

CREATE TABLE myschema.mytable(mycol  CHAR(10));

Bibliography