stored procedures: sybase -> postgreSQL ?

From: Charles Hauser <chauser(at)duke(dot)edu>
To: PSQL_list <pgsql-sql(at)postgresql(dot)org>
Subject: stored procedures: sybase -> postgreSQL ?
Date: 2002-09-09 18:15:53
Message-ID: 1031595353.774.55.camel@pandorina.biology.duke.edu
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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)
go

exec sp_primarykey DnaFragment,
dna_fragment_id
go

exec 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

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Tom Lane 2002-09-09 20:26:42 Re: Slow Multi-joins performance [DEVELOPERS attn please]
Previous Message mallah 2002-09-09 17:52:41 Re: Displaying current queries on the database?