CODEWITHSUNDEEP
postgresqltriggersprocedures
Nurjan
Nurjan

Reputation: 6073

postgresql procedures/triggers

Is it possible to write a stored procedure or trigger that will be executed automatically inside of a database on particular time without any calls from application? If yes, then could anybody give me an example or link to some resource where I can read how to do that.

Upvotes: 3

Views: 224

Answers (3)

ScoRpion
ScoRpion

Reputation: 11474

You can use Stored Procedures. Stored Procedure is a set of statements, which allow ease and flexibility for a programmer because stored procedure is easy to execute than reissuing the number of individual SQL statements but they need to perform the same database operations.Using the stored procedure less information needs to be sent between the server and the client.

You can visit These links :-

  1. Postgres Procedures

  2. Best way to use stored Procedures

Upvotes: 2

Barend
Barend

Reputation: 17419

Check out pgAgent. If that doesn't work for you, there's always cron in Unix/Linux and the Task Scheduler service in Windows.

Upvotes: 3

Christian Uhl
Christian Uhl

Reputation: 372

I don't think there's anything built-in, but you might want to check out pgjobs or pgAgent.

Upvotes: 3

Related Questions