$ psql
psql (9.2.4)
Type "help" for help.
# CREATE TABLE IF NOT EXISTS my_table (foo INT, bar VARCHAR (25) );
CREATE TABLE
# \d my_table 
          Table "public.my_table"
 Column |         Type          | Modifiers 
--------+-----------------------+-----------
 foo    | integer               | 
 bar    | character varying(25) |