Re: [SQL] retrieve the tables names based on the owner

2004-08-06 Thread Achilleus Mantzios
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 > Antoni

[SQL] retrieve the tables names based on the owner

2004-08-06 Thread Antonis Antoniou
Hi guys, How can I retrieve (with a query) from a database, only the table names based on the owner name? Many Thanks Antonis ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster