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
---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faqs/FAQ.html
