[SQL] Re: Get the tables names?

[Nils Zonneveld]

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

---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?

http://www.postgresql.org/search.mpl