stored procedures: sybase -> postgreSQL ? - Mailing list pgsql-sql

From Charles Hauser
Subject stored procedures: sybase -> postgreSQL ?
Date
Msg-id 1031595353.774.55.camel@pandorina.biology.duke.edu
Whole thread Raw
List pgsql-sql
I am trying to port a Sybase table create script to one usable for
postgreSQL.

(note I am not a DBA)

In particular I am not well versed on how to use/recode the stored
procedures such as that in the example below.

ALTER TABLE DnaFragment       ADD PRIMARY KEY (dna_fragment_id)
goexec sp_primarykey DnaFragment,      dna_fragment_id
goexec sp_bindrule DnaFragment_type_rule, 'DnaFragment.type'exec sp_bindefault Set_To_Current_Date,
'DnaFragment.date_last_modified'exec sp_bindefault Set_to_False, 'DnaFragment.is_obsolete'
go



regards,

Charles




pgsql-sql by date:

Previous
From:
Date:
Subject: Re: Displaying current queries on the database?
Next
From: Tom Lane
Date:
Subject: Re: Slow Multi-joins performance [DEVELOPERS attn please]