Thread

1. Show tables!

   Luiz Antonio <luiz@supersoft.com.br> — 2000-06-23T15:20:33Z

   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!!!
   
   Bye
   
   Luiz
   
   
   
   

2. Re: Show tables!

   Lamar Owen <lamar.owen@wgcr.org> — 2000-06-23T15:44:22Z

   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
   
   

3. Re: Show tables!

   NRonayette <r97m10@socotec.fr> — 2000-06-23T16:42:05Z

   \d
   
   and 
   
   \? gives you all the \<command>
   
   Nicolas
   
   Luiz Antonio a écrit :
   > 
   > 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!!!
   > 
   > Bye
   > 
   > Luiz