On Wed, May 19, 2010 at 9:39 AM, mnavahan <mnavahan@yahoo.com> wrote:
>
> I try to move from firebird to postgresql But it seems some option to do hold
> ..
>
>
> 1. In grant section in some reason user ROLE R1 can Access to function F1
> and F1 can access to Table T1 bUT user must not be granted to work directly
> to table T1
>
> In firebird ,I can invoke grant to object
> GRANT SELECT, INSERT ON T1 TO PROCEDURE F1;
>
> Can I do the same with postgresql or other ways to do this job ?
I think so. Look up "SECURITY DEFINER"
> 2. In new firebird 2.1.3, I have some "DATABASE TRIGGER" for user to connect
> & disconnect or start & finish database or transaction . Do we have same
> trigger or any ways in PG to do the same ?
Not that I know of. You're talking connect / disconnect triggers right?
> 3.I work with pgadmin3 and it is very nice and free ... also I have checked
> many other commercial experts such as novicat, pgmanager,maestro.... BUT
> I did not find any editor as POWERFUL as IBEXPERT for firebird.
> Is there any Powerful editor as powerful as IBEXPERT in PG ?
I use nano or vi for most stuff. Both can do color coding quite
nicely for .sql files.