Execute a String Sql in PostgreSQL [duplicate]

Question

In a function, I have a SELECT query in a string, for example:

sql='SELECT * FROM A'

I want to execute sql output result of: SELECT * FROM A

How can I execute the string sql in PostgreSQL?

stackoverflow.com/questions/10709624/dynamic-query-postgres

Vinit Prajapati
– Vinit Prajapati

2013-07-25 10:40:12 +00:00
Commented Jul 25, 2013 at 10:40 — Vinit Prajapati
– Vinit Prajapati, Commented Jul 25, 2013 at 10:40

user2478690 · Accepted Answer · 2013-07-25 15:08:43Z

9

Inside a function use EXECUTE.
http://www.postgresql.org/docs/current/interactive/plpgsql-statements.html#PLPGSQL-STATEMENTS-EXECUTING-DYN

answered Jul 25, 2013 at 15:08

user2478690

4512 silver badges4 bronze badges

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

Comments

Vinit Prajapati · Accepted Answer · 2013-07-25 10:42:31Z

-1

below one works fine in postgres 8.4

UDBI=> PREPARE query as select 1 as a;
PREPARE
UDBI=> PREPARE query
UDBI=> EXECUTE query;
 a 
---
 1
(1 row)

UDBI=>

answered Jul 25, 2013 at 10:42

Vinit Prajapati

1,6131 gold badge18 silver badges30 bronze badges

1 Comment

IMSoP Over a year ago

This is not a dynamic query - the select 1 as a part is not sent as a string, but as part of the SQL statement. If executed immediately and once only like this, it is equivalent to just typing select 1 as a; on its own.

Collectives™ on Stack Overflow

Execute a String Sql in PostgreSQL [duplicate]

2 Answers 2

Comments

1 Comment

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

1 Comment

Linked

Related