Re: [SQL] grant select,... over schema

[Michael James]

GRANT ALL PRIVILEGES ON databaseName To username;

Michael Lee James | Database Administrator
d. 480-282-6043| c. 480-505-5802| f. 480-505-5801 
[EMAIL PROTECTED]
iCrossing, Inc. | Driving the Future of Advertising
New York | Chicago | Scottsdale | San Francisco
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of chester c young
Sent: Tuesday, February 28, 2006 9:35 AM
To: pgsql-sql@postgresql.org
Subject: [SQL] grant select,... over schema

is there any way to grant over all applicable objects in a schema,

> grant select on schema pop to public; <-- wrong

without specifically granting the select on each table?

__
Do You Yahoo!?
Tired of spam?  Yahoo! Mail has the best spam protection around 
http://mail.yahoo.com 

---(end of broadcast)---
TIP 9: In versions below 8.0, the planner will ignore your desire to
   choose an index scan if your joining column's datatypes do not
   match

iCrossing Privileged and Confidential Information
This email message is for the sole use of the intended recipient(s) and may 
contain confidential and privileged information of iCrossing. Any unauthorized 
review, use, disclosure or distribution is prohibited. If you are not the 
intended recipient, please contact the sender by reply email and destroy all 
copies of the original message.



---(end of broadcast)---
TIP 2: Don't 'kill -9' the postmaster

Re: [SQL] schema inspection

[Michael James]

Pgadmin is a good GUI interface if you want that same info, but pg_catalog is a 
better tool

-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Achilleus 
Mantzios
Sent: Thursday, March 16, 2006 9:45 AM
To: [EMAIL PROTECTED]
Cc: pgsql-sql@postgresql.org
Subject: Re: [SQL] schema inspection

O [EMAIL PROTECTED] έγραψε στις Mar 16, 2006 :

> Hi,
> 
> supposing to have a small DB:
> 
> TABLE a (
>   id SERIAL PRIMARY KEY
> );
> 
> TABLE b (
>   id SERIAL PRIMARY KEY,
>   idA INTEGER NOT NULL REFERENCES a(id)
> );
> 
> How can I inspect pg_schema/information_schema to "detect" the 
> relation between "b" and "a" via "idB"?
> 

pg_catalog.pg_constraint is your (only?) friend.

> TIA
> Roberto Colmegna
> 
> 
> 
> 
>   
> Tiscali ADSL 4 Mega Flat
> Naviga senza limiti con l'unica Adsl a 4 Mega di velocitΓ  a soli 19,95 β?¬ 
> al mese!
> Attivala subito e hai GRATIS 2 MESI e l'ATTIVAZIONE. 
> http://abbonati.tiscali.it/banner/middlepagetracking.html?c=webmailadsl&r=http://abbonati.tiscali.it/adsl/sa/4flat_tc/&a=webmail&z=webmail&t=14
> 
> ---(end of broadcast)---
> TIP 3: Have you checked our extensive FAQ?
> 
>http://www.postgresql.org/docs/faq
> 

-- 
-Achilleus


---(end of broadcast)---
TIP 9: In versions below 8.0, the planner will ignore your desire to
   choose an index scan if your joining column's datatypes do not
   match

iCrossing Privileged and Confidential Information
This email message is for the sole use of the intended recipient(s) and may 
contain confidential and privileged information of iCrossing. Any unauthorized 
review, use, disclosure or distribution is prohibited. If you are not the 
intended recipient, please contact the sender by reply email and destroy all 
copies of the original message.



---(end of broadcast)---
TIP 9: In versions below 8.0, the planner will ignore your desire to
   choose an index scan if your joining column's datatypes do not
   match