Hi,
i am a novice at PostGreSQL
but have some idea of MsSqlServer
Migrating to PostGreSql, i need to know how capable pgsql Functions are , Vis a Vis SQLServer.
can pgsql functions replace all functionality provided by Stored Procedures of MSSqlServer
specifically:
1. do pgsql Functions
a.> return datasets
b.> return output parameters
2. does PostGreSQL have an equivalent to Triggers of SQLServer
i'd also appreciate any links to find out about
the possibility of exporting
data
relations
stored procs / functions / Triggers
from PostGreSQL database.
Thanks In Advance
regards
-adivi