Skip site navigation (1) Skip section navigation (2)

Peripheral Links

Header And Logo

PostgreSQL
| The world's most advanced open source database.

Site Navigation

Search for
  Advanced Search

BUG #2850: Cannot select from information_schema.schemat



The following bug has been logged online:

Bug reference:      2850
Logged by:          Tony Marston
Email address:      tony(at)marston-home(dot)demon(dot)co(dot)uk
PostgreSQL version: 8.2
Operating system:   Windows XP
Description:        Cannot select from information_schema.schemat
Details: 

If I am logged on as a user other than 'postgres' and I try the query

SELECT * FROM information_schema.schemata

I get no results. Yet if I try the equivalent query

SELECT * FROM pg_namespace

I can see all the available schema names.

Why is there a difference when the two queries are supposed to provide the
same results?



Home | Main Index | Thread Index

Privacy Policy | PostgreSQL Archives hosted by Command Prompt, Inc. | Designed by tinysofa
Copyright © 1996 – 2008 PostgreSQL Global Development Group