Re: to get the list of schemas in postgresql db

The same way you will do it without perl, select * from pg_namespace I guess.

Comment on Re: to get the list of schemas in postgresql db Download Code

Replies are listed 'Best First'.
Re^2: to get the list of schemas in postgresql db by ansh batra (Friar) on Nov 22, 2011 at 06:36 UTC
ur query is correct zwon but for that i need to connect to a database first cant we supply the database name in the query itself?? thanks	[reply]
Re^3: to get the list of schemas in postgresql db by Tux (Canon) on Nov 22, 2011 at 07:06 UTC
Easy answer :) : No Enjoy, Have FUN! H.Merijn	[reply]
Re^4: to get the list of schemas in postgresql db by ansh batra (Friar) on Nov 22, 2011 at 07:08 UTC
thanks tuk atleast ill not be wasting time now EDIT : we cannot interact with a db without connecting to it sorry i forgot that	[reply]