E:\www\korteriyhistu\sql>psql postgres johu
Welcome to psql 8.2.4, the PostgreSQL interactive terminal.

Type:  \copyright for distribution terms
       \h for help with SQL commands
       \? for help with psql commands
       \g or terminate with semicolon to execute query
       \q to quit

Warning: Console code page (437) differs from Windows code page (1252)
         8-bit characters may not work correctly. See psql reference
         page "Notes for Windows users" for details.

postgres=# select table_name from information_schema.tables
postgres-# where table_type = 'BASE TABLE'
postgres-# and table_schema = 'public'
postgres-#