Re: all tables in a DB\?

Hi
Try the following SQL-Command:

SELECT relname
FROM pg_class
WHERE relname NOT LIKE 'pg_%';

In the table 'pg_class' you will find all tables created in the database.
Also the system-tables called pg_... (like pg_class).
greetings
rolf

"D'laila Pereira" <dlailap(at)home(dot)com> schrieb im Newsbeitrag
news:Xh2c8(dot)20270$tg4(dot)228609(at)vixen(dot)cso(dot)uiuc(dot)edu(dot)(dot)(dot)
> What SQL command can I issue in Postgresql to list all the tables in a
> database?
>
>
>
>