show tables in postgresql

Question

How do you say "show tables" (mysql) in Postgresql?

Answer 1

From the psql CLI, enter the \dt command. Programmatically (or from the psql interface too, of course),

SELECT * FROM pg_catalog.pg_tables

(the system tables live in the pg_catalog database.)

Answer 2

Moocha's answer is correct. Alternatively, you can use the pgadmin3 gui admin tool, or pgphpadmin.

Answer 3

(For completeness)

You could also query the (SQL-standard) information schema:

SELECT
    table_schema || '.' || table_name
FROM
    information_schema.tables
WHERE
    table_type = 'BASE TABLE'
AND
    table_schema NOT IN ('pg_catalog', 'information_schema');