Execute Query string in postgreSQL

Question

I have a query string in variable

suppose Select Now(); I want to execute it same like SQL do. I use

Execute 'Select Now()';

But It throws an exception

prepared statement "SELECT now()" does not exist

and not allow me to execute it.

Is there any way to do that?

This is simplest one I tried. I will make function if it execute. — Pooja-G, Dec 01 '16 at 10:26
you can't use `execute` in SQL, this is a PL/pgSQL statement. You need a function (or a `do` block) — a_horse_with_no_name, Dec 01 '16 at 10:30
Possible duplicate of [dynamic sql query in postgres](http://stackoverflow.com/questions/12780275/dynamic-sql-query-in-postgres) — JimmyB, Dec 01 '16 at 10:33

score 2 · Answer 1 · answered Dec 01 '16 at 10:30

2

You mess plpgsql EXECUTE:

t=# do $$ begin execute 'select now()'; end; $$;
DO

and SQLEXECUTE.

t=# prepare example as select now();
PREPARE
t=# execute example;
              now
-------------------------------
 2016-12-01 10:30:15.782433+00
(1 row)

answered Dec 01 '16 at 10:30

Vao Tsun

42,665
8
85
115

I am using pgAdmin. How it execute in it? – Pooja-G Dec 01 '16 at 10:42

score -1 · Answer 2 · answered Dec 01 '16 at 10:48

-1

'Select Now()' Run like this in pgadmin

answered Dec 01 '16 at 10:48

Marlon Abeykoon

10,709
4
53
72

Execute Query string in postgreSQL

2 Answers2