By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
448,871 Members | 1,046 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 448,871 IT Pros & Developers. It's quick & easy.

Stored Procedures in PostgreSQL

P: 3
hi I'm changind of BD from SQL to postgreSQL and I wanna know how to do this stored procedure in postgres

Expand|Select|Wrap|Line Numbers
  1. create Procedure [dbo].[ConsultarDepartamento]
  2. As
  3.     BEGIN
  4.         Select * From Departamento
  5.     END
May 25 '07 #1
Share this Question
Share on Google+
1 Reply

Expert 100+
P: 534
Please read the Posting Guidelines at the top of the Forum, particularly the section about using formatting tags (CODE, etc)

Stored procedures in Postgresql are implemented as functions.
Start with reading these manuals, if you have any problems with implementation post your questions or your code and we'll take it from there.

SQL Functions
Porting from Oracle functions
May 27 '07 #2

Post your reply

Sign in to post your reply or Sign up for a free account.