How to Substitute Variables in PostgreSQL

Question

The given Oracle query inserts data into table by substituting variables. How I achieve the same in PostgreSQL?

INSERT INTO control_threshold (
    threshold_id, group_name, description, sql, low_value, high_value)
VALUES(
    threshold_seq.nextval, '&2', '&1',  TRIM('&5' || '&6' || '&7' || '&8' || '&9'),
    trim('&3'), trim('&4'));

In reference to your deleted question: That deleted my answer as well, and I don't think your question was completely unfounded. There has been confusion before. I suggest you undelete it and edit in that your version of Postgres did not seem to support the type hstore. — Erwin Brandstetter
– Erwin Brandstetter, Commented Jul 14, 2014 at 19:05

Colin 't Hart · Accepted Answer · 2014-05-07 15:30:39Z

7

These variables are a feature of SQL*Plus.

psql, the equivalent program in the PostgreSQL world, also has variables.

Use

\set variable 'value'

and

insert into mytable(mycolumn)
values (:variable);

answered May 7, 2014 at 15:30

Colin 't Hart

9,52015 gold badges37 silver badges44 bronze badges

Add a comment |

Stack Exchange Network

How to Substitute Variables in PostgreSQL

1 Answer 1

Your Answer

Hot Network Questions

How to Substitute Variables in PostgreSQL

1 Answer 1

Your Answer

Sign up or log in

Post as a guest

Related

Hot Network Questions