Re: Get the tables names?

Magnus Landahl wrote:
>
> Hi everybody!
>
> Is it possible to get the names of all tables in the database with a sql
> query??
>

select tablename from pg_tables where tablename !~ '^pg_';

or more SQL92 like:

select tablename from pg_tables where tablename not like 'pg_%';

Kind regards,

Nils Zonneveld

--
Alles van waarde is weerloos
Lucebert