Choose style:

Author Topic: PostgreSQL - Question [RESOLVED]  (Read 170 times)

0 Members and 1 Guest are viewing this topic.

Offline grafiksinc

  • Member
  • ***
  • Posts: 132
  • Karma: 8
    • View Profile
  • Peppermint version(s): 7
PostgreSQL - Question [RESOLVED]
« on: January 08, 2018, 08:05:50 am »
Forum, at my day job I am a .NET developer on the Microsoft stack.  :'(
But since last year I have been working on porting an enterprise .NET application to use a Linux stack.  ;)
With MONO for the.NET and PostgreSql for the database.
To be honest I thought,  it would be more difficult but,  things have been pretty smooth for the port .....no real hard issues we could not overcome.

Anyway  :D,  my question is about "StoredProcedures".
I use them often  in MSSQL but as you know PosgreSql does not have this feature so to speak.
I been out on stack-overflow, PostgreSQL, and a few other site but nothing yet that did a good job explaining the equivalent

If there are any PostgreSql folks on here, I was wondering  if you could  recommend any good links that explains stored procedures equivalent  ;)

If not that is OK too, I just thought I would ask  :)

--Thanks in Advance!

 

« Last Edit: January 08, 2018, 07:39:32 pm by grafiksinc »

Offline PCNetSpec

  • Administrator
  • Hero
  • *****
  • Posts: 18574
  • Karma: 2172
  • "-rw-rw-rw-" .. The Number Of The Beast
    • View Profile
    • PCNetSpec
  • Peppermint version(s): Peppermint 8 Respin (64bit)
Re: PostgreSQL - Question
« Reply #1 on: January 08, 2018, 08:52:30 am »
First let me explain I'm NOT a database developer by any stretch of the imagination :)

But this (and the tutorial linked at the bottom) seems to suggest PostgreSQL does support stored procedures:
http://www.postgresqltutorial.com/introduction-to-postgresql-stored-procedures/
WARNING: You are logged into reality as 'root' .. logging in as 'insane' is the only safe option.

Team Peppermint
PCNetSpec

Offline grafiksinc

  • Member
  • ***
  • Posts: 132
  • Karma: 8
    • View Profile
  • Peppermint version(s): 7
Re: PostgreSQL - Question
« Reply #2 on: January 08, 2018, 07:38:56 pm »
What!!!..... I been working PostgreSQL for a year now and not once have I run across this site......LOL  :-[

Thanks! it is what I was looking for.  ;D