Pallav Kalva wrote:
> Also here is the privileges information from information_schema
> tables. Is there a way to REVOKE these
> privileges ?
You need to log in as the user that has granted the privilege you want
to revoke. In this case, log in as postgres and do REVOKE ALL FROM
PUBLIC;.
--- Yudie <[EMAIL PROTECTED]> wrote:
> Great the function works, but what does it means?
> SELECT $1 ~ ''^[0-9]+$''
>
> Yudie
"~" is the regular expression match operator; the text
inside the quotes is a regular expression. Look here
for a reference:
http://www.postgresql.org/docs/7.2/interact
