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

\d

and

\? gives you all the \<command>

Nicolas

Luiz Antonio a �crit :