Firebird To postgresql migration help needed - Mailing list pgsql-admin

From mnavahan
Subject Firebird To postgresql migration help needed
Date
Msg-id 28610086.post@talk.nabble.com
Whole thread Raw
Responses Re: Firebird To postgresql migration help needed  (Scott Marlowe <scott.marlowe@gmail.com>)
List pgsql-admin
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 ?


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 ?


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 ?


--
View this message in context:
http://old.nabble.com/Firebird-To-postgresql-migration-help-needed-tp28610086p28610086.html
Sent from the PostgreSQL - admin mailing list archive at Nabble.com.


pgsql-admin by date:

Previous
From: "Josi Perez (3T Systems)"
Date:
Subject: Trigger with dynamic SQL
Next
From: Scott Marlowe
Date:
Subject: Re: Firebird To postgresql migration help needed