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
