Thread: Looking into the INFORMATION_SCHEMA
Hello, About the next pgadmin: I hope to catch up with the Danish translation soon. A thought: How about providing access to the INFORMATION_SCHEMA of a database, in addition to other, 'normal' schemas, like 'public'? -- Greetings from Troels Arvin, Copenhagen, Denmark
On Fri, 2004-09-03 at 08:33 +0000, Andreas Pflug wrote: > > About the next pgadmin: I hope to catch up with the Danish translation > > soon. > > Fine! By the way, I spotted an un-localized string in the "Users" part of the object tree: The "Member of" string in the attributes for a user object isn't localized. > > A thought: How about providing access to the INFORMATION_SCHEMA of a > > database, in addition to other, 'normal' schemas, like 'public'? > > You *do* have access to it; just enable system objects. Works; thanks to you and Dave. > Though I can't imagine what that should be good for. I'm writing code which inspects table metadata. The code uses the INFORMATION_SCHEMA (so it can be re-used on an MSSQL server) which is quite overwhelming, making a GUI like pgadmin a nice exploration tool. -- Greetings from Troels Arvin, Copenhagen, Denmark
> -----Original Message----- > From: pgadmin-hackers-owner@postgresql.org > [mailto:pgadmin-hackers-owner@postgresql.org] On Behalf Of > Troels Arvin > Sent: 02 September 2004 21:21 > To: pgadmin-hackers@postgresql.org > Subject: [pgadmin-hackers] Looking into the INFORMATION_SCHEMA > > Hello, > > About the next pgadmin: I hope to catch up with the Danish > translation soon. :-) > A thought: How about providing access to the > INFORMATION_SCHEMA of a database, in addition to other, > 'normal' schemas, like 'public'? Just switch on 'System Objects' on the View menu and you should see it. Regards, Dave
Troels Arvin wrote: > Hello, > > About the next pgadmin: I hope to catch up with the Danish translation > soon. Fine! > A thought: How about providing access to the INFORMATION_SCHEMA of a > database, in addition to other, 'normal' schemas, like 'public'? You *do* have access to it; just enable system objects. Though I can't imagine what that should be good for. Regards, Andreas
Troels Arvin wrote: > > By the way, I spotted an un-localized string in the "Users" part of the > object tree: The "Member of" string in the attributes for a user object > isn't localized. Thx, Fixed. Regards, Andreas
On Sun, 05 Sep 2004 17:14:23 +0000, Andreas Pflug wrote: >> By the way, I spotted an un-localized string in the "Users" part of the >> object tree: The "Member of" string in the attributes for a user object >> isn't localized. > > Thx, Fixed. Nice. I guess that pgadmin3.pot should be updated, then? -- Greetings from Troels Arvin, Copenhagen, Denmark
Troels Arvin wrote: > > Nice. I guess that pgadmin3.pot should be updated, then? You win! :-) Regards, Andreas