Re: Show tables!

Luiz Antonio wrote:
>
> Hi people!!!
> Does anybody know how I can execute a comand as the comand show tables that
> exist in teh MySQL database?
> Does exist some comand that show all tables of a database???
> If somebody can help me...thanks!!!

\dt in psql.

The SQL to do this:
SELECT relname FROM pg_class WHERE relkind='r';

This will give you all tables in the system, including system catalogs.
If you don't want system catalogs, pgaccess stuff, and pgadmin stuff,
then:

SELECT relname FROM pg_class
WHERE relkind='r'
and relname !~ '^pg_'
and relname !~ '^pga_'
and relname !~ '^pgadmin_';

--
Lamar Owen
WGCR Internet Radio
1 Peter 4:11