Dynamic SQL PostgreSQL

Question

I want to know the basics of dynamic sql especially in PostgreSQL. I was googling for a while but have no luck for getting a good described examples. Maybe someone here could give me some links to the materials from which you where studying this subject.

Ok so to be more accurate I am interested in examples of especially PL/SQL (PostgreSQL) code which will demonstrate examples with description :)

Can you be a little less vague? What are you trying to do?

Daniel Lyons
– Daniel Lyons

2011-09-09 05:49:57 +00:00
Commented Sep 9, 2011 at 5:49 — Daniel Lyons
– Daniel Lyons, Commented Sep 9, 2011 at 5:49
I am not trying to do anything yet I want to learn it.

Gabriel Filipiak
– Gabriel Filipiak

2011-09-09 13:18:05 +00:00
Commented Sep 9, 2011 at 13:18 — Gabriel Filipiak
– Gabriel Filipiak, Commented Sep 9, 2011 at 13:18

plang · Accepted Answer · 2011-09-09 05:55:20Z

1

Here is a good place to start: http://www.postgresql.org/docs/9.1/static/plpgsql-statements.html#PLPGSQL-STATEMENTS-SQL-NORESULT

Look in particular at section called "Executing Dynamic Commands".

answered Sep 9, 2011 at 5:55

plang

5,6643 gold badges29 silver badges37 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Gabriel Filipiak Over a year ago

Thx I will look at it, any other materials?

Gabriel Filipiak Over a year ago

so correct me if I am wrong: Dynamic SQL are simply commands executed via pl/sql sript code? In link provided above there are not many simple examples :)

Collectives™ on Stack Overflow

Dynamic SQL PostgreSQL

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related