Thread: PostGreSql equivalents to mssql

PostGreSql equivalents to mssql

From
"adivi"
Date:
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

Re: PostGreSql equivalents to mssql

From
Date:
> 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
>

Dear Adivi ,

Congratulations on choosing the most advanced  opensource database on earth.
You can expect all the support from the nice people residing here ;-)

>    specifically:
>     1. do pgsql Functions
>        a.> return datasets

yes postgresql 7.3.x  CAN
check
http://techdocs.postgresql.org/guides/SetReturningFunctions
for details.

>        b.> return output parameters

I dont get this question very much, someone else might be
able to help u here.

>
>     2. does PostGreSQL have an equivalent to Triggers of SQLServer

Yes very much,
check Triggers sections in the postgresql Documentation.

>
>
> i'd also appreciate any links to find out about
>
>    the possibility of exporting
>        data
>        relations
>        stored procs / functions / Triggers
>
>    from PostGreSQL database.


check http://techdocs.postgresql.org/#convertfrom
and specifically the
#

Microsoft SQL Server
# Converting your data from MS SQL Server 7 to PostgreSQL 7.1.x by Ryan C.
Bonham#HOWTO : Microsoft SQL Server to PostgreSQL Migration by Ian Harding

Section.



>
> Thanks In Advance
>
> regards
> -adivi



-----------------------------------------
Get your free web based email at trade-india.com.
   "India's Leading B2B eMarketplace.!"
http://www.trade-india.com/



Re: PostGreSql equivalents to mssql

From
"Maksim Likharev"
Date:
>        b.> return output parameters

>I dont get this question very much, someone else might be
>able to help u here.

You cannot have [out] parameters in term of MS TSQL word,
but your function could return a complex type, that will do a trick.
Still you cannot return a recordset and [out] params, but do you need
it?

Re: PostGreSql equivalents to mssql

From
Alvaro Herrera
Date:
On Sat, Jul 05, 2003 at 11:58:40PM -0700, Maksim Likharev wrote:
> >        b.> return output parameters
>
> >I dont get this question very much, someone else might be
> >able to help u here.
>
> You cannot have [out] parameters in term of MS TSQL word,
> but your function could return a complex type, that will do a trick.
> Still you cannot return a recordset and [out] params, but do you need
> it?

If you need both, you can use a temp table...

--
Alvaro Herrera (<alvherre[a]dcc.uchile.cl>)
"Aprender sin pensar es inutil; pensar sin aprender, peligroso" (Confucio)

Re: PostGreSql equivalents to mssql

From
"Maksim Likharev"
Date:
Unfortunately I cannot tell you much about Postgres on Unix and client
on Windows, but all my test apps written on VB and PG running on Linux,
so this combination works and I think should not be much pain for you as
well.
Would be interesting to here real success story of happy marriage of
postgres and ADO.



-----Original Message-----
From: adivi [mailto:adivi@maximizelearning.com]
Sent: Sunday, July 06, 2003 10:41 PM
To: Maksim Likharev
Subject: Re: [GENERAL] PostGreSql equivalents to mssql


thanks for the caution Maksim ,

    but i do need to have my database on PostGreSql running on a
unix/linux
box.
    and i just need to have the application on Windows + .Net

    i can use odbc.net or inherit the adapter

    do you still see any possibility of serious issues !?
    please do let me know if i am headed in the wrong direction

regards
-adivi

----- Original Message -----
From: "Maksim Likharev" <mlikharev@aurigin.com>
To: "adivi" <adivi@maximizelearning.com>
Sent: Monday, July 07, 2003 10:58 AM
Subject: RE: [GENERAL] PostGreSql equivalents to mssql


So I would tell you, before doing something ask yourself what is you
goal,
if you shop primary OS is MS Windows and client is
VB or .Net or more generally ADO 2.7.x you'll probably looking into
wrong direction,
because nothing works better with ADO then MS SQL Server.
I am not telling you that postgres will not suite you, that will if you
are
following certain pattern.
What is you goal?



-----Original Message-----
From: adivi [mailto:adivi@maximizelearning.com]
Sent: Sunday, July 06, 2003 9:12 PM
To: Maksim Likharev
Subject: Re: [GENERAL] PostGreSql equivalents to mssql


thanks for the reply:

    but Functions can do return Cursor !
    can i parse them from a .Net application ?

    also i've found that PostGreSql 7.3 + can return recordset
    http://techdocs.postgresql.org/guides/SetReturningFunctions

please reply if i can parse , using a .Net application or any such fromt
end
application,
    a.> cursors returned by a PostGreSql function
    b.> recordset ( multiple rows and columns ) returned by a PostGreSql
function

regards
-adivi
----- Original Message -----
From: "Maksim Likharev" <mlikharev@aurigin.com>
To: <mallah@trade-india.com>; <adivi@maximizelearning.com>
Cc: <pgsql-general@postgresql.org>
Sent: Sunday, July 06, 2003 12:28 PM
Subject: RE: [GENERAL] PostGreSql equivalents to mssql


>        b.> return output parameters

>I dont get this question very much, someone else might be
>able to help u here.

You cannot have [out] parameters in term of MS TSQL word,
but your function could return a complex type, that will do a trick.
Still you cannot return a recordset and [out] params, but do you need
it?


Re: PostGreSql equivalents to mssql

From
Jean-Michel POURE
Date:
On Sunday 06 July 2003 08:44, mallah@trade-india.com wrote:
> >    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

Dear Adivi,

You may also have a look at pgAdmin3, PostgreSQL administration GUI for Win32,
GNU/Linux and FreeBSD. pgAdmin3 has very nice features to write server-side
code.

Daily snapshots can be downloaded from:
http://cvs.pgadmin.org/cgi-bin/viewcvs.cgi/*checkout*/pgadmin3/docs/en_US/snapshots.html

Also, if I read your email correctly, are you from India? We already have 21
languages in preparation. India, with 1,6 billion inhabitants by 2040, is one
of our main targets. If you would like to translate pgAdmin3 into Indi,
please refer to this documentation:

http://cvs.pgadmin.org/cgi-bin/viewcvs.cgi/*checkout*/pgadmin3/docs/en_US/translation_steps.html
http://cvs.pgadmin.org/cgi-bin/viewcvs.cgi/*checkout*/pgadmin3/docs/en_US/translation_guidelines.html
http://cvs.pgadmin.org/cgi-bin/viewcvs.cgi/*checkout*/pgadmin3/docs/en_US/translation_team.html

Best regards,
Jean-Michel