Re: retrieve the tables names based on the owner - Mailing list pgsql-sql

O kyrios Antonis Antoniou egrapse stis Aug 6, 2004 :

> Hi guys,

Kalhmera Antoni!

> 
> How can I retrieve (with a query) from a database, only the table names 
> based on the owner name?
> 

SELECT schemaname||'.'||tablename from pg_tables where 
tableowner='postgres';


> 
> Many Thanks
> Antonis
> 
> 
> ---------------------------(end of broadcast)---------------------------
> TIP 4: Don't 'kill -9' the postmaster
> 

-- 
-Achilleus