Need help accessing TABLES, COLUMNS, DESCRIPTIONS
| От | Robert Paresi |
|---|---|
| Тема | Need help accessing TABLES, COLUMNS, DESCRIPTIONS |
| Дата | |
| Msg-id | ihc66n$oap$1@news.hub.org обсуждение исходный текст |
| Ответы |
Re: Need help accessing TABLES, COLUMNS, DESCRIPTIONS
|
| Список | pgsql-general |
Hello,
I can't figure this out, and need help.
I need access (VIA SQL Statements) to retreive a list of all PUBLIC tables,
columns and their descriptions.
I found:
tables
columns
pg_description
1. There is no link between the description (object ID and the
tables/columns)
2. pg_descriptions seems to be in another place than tables/columns, why?
(inaccessible)
3. I also need access to the user (table of users) and which tables they
have access to.
Meaning, an sql statement that says:
Give me all the tables, columns and descriptions of all the PUBLIC tables a
particular user has access to:
For example:
select table,table_object_id, column, column_object_Id,
isColumnPrimaryKey,Column_Description
from tables,columns,pg_descriptions
join (tell me)
where they are 'public' tables and are accessible by user
'ReportUser'
I can do this in Sybase SQL Anywhere very easily.
I need to do it in PostGreSQL 9
Thank you.
В списке pgsql-general по дате отправления: