Re: DatabaseMetaData.getCatalogs()

jason(at)netspade(dot)com writes:

> Okay here's a context diff against CVS for getting table privileges. I may have more code to add (I noticed getColumnPrivileges() is not completed - could use my routine for parsing pg_class.relacl?).

The list of columns you return is wrong. There is no COLUMN_NAME column.
TABLE_CAT should be filled in with the database name (should be available
via getConnection().getCatalog()). A missing TABLE_SCHEM should be set to
null (in the SQL sense). Also you have GRANTOR and GRANTEE mixed up,
besides the fact that PostgreSQL doesn't store the GRANTEE at all (yet).

--
Peter Eisentraut peter_e(at)gmx(dot)net http://funkturm.homeip.net/~peter