Обсуждение: 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