SQL list table names

From: alviN <gamboa(at)infophil(dot)com>
To: pgsql-sql <pgsql-sql(at)postgresql(dot)org>
Subject: SQL list table names
Date: 2003-01-07 10:46:39
Message-ID: 3E1AB00F.1040207@infophil.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice 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

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Adam Witney 2003-01-07 11:03:15 Re: SQL list table names
Previous Message Josh Berkus 2003-01-06 22:43:33 Re: PostgreSQL-7.1.3 Installation Problem

Browse pgsql-sql by date

  From Date Subject
Next Message Adam Witney 2003-01-07 11:03:15 Re: SQL list table names
Previous Message Tambet Matiisen 2003-01-07 08:46:36 Re: Sorry, to many clients already