SQL list table names - Mailing list pgsql-sql

is it possible to execute an sql query to be able to list the tables's 
names?
well, you can do it on psql using \dt. but im talking about the SQL 
statement, because i want to execute that query from a script.

thanks.



alviN