pgAdmin Create Variable [duplicate]

Question

I am trying to create a simple variable in pgAdmin (PostgreSQL) but it is not working. Can someone help me out please? I am probably just doing something dumb.

DECLARE @Variable;
...error
ERROR:  syntax error at or near "@"
LINE 88:  DECLARE @Variable;
                  ^

DECLARE @Variable text;
...error
ERROR:  syntax error at or near "@"
LINE 88:  DECLARE @Variable text;
                  ^

DECLARE Variable;
...error
ERROR:  syntax error at or near ";"
LINE 88:  DECLARE Variable;
                          ^

sticky bit · Accepted Answer · 2019-06-10 18:37:03Z

4

Looks like you're trying to use SQL Server syntax in Postgres. That won't work.

Don't prepend @ to the variable name. And you have to declare all in one DECLARE block preceding the BEGIN ... END; block.

For example:

DO
$$
DECLARE
  x1 text = 'Hello';
  x2 text = 'World';
BEGIN
  RAISE NOTICE '%', x1 || ' ' || x2 || '!';
END;
$$
LANGUAGE plpgsql;

That raises a notice with the text of "Hello World!".

edited Jun 10, 2019 at 18:37

answered Jan 16, 2019 at 12:45

sticky bit

37.7k12 gold badges34 silver badges46 bronze badges

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

2 Comments

Freddy Bonda Over a year ago

This really really sucks. I mean I just want to create one simple variable to use in my other calls. And now I need to do all this...but thank you :) Appreciate it!

Rejwanul Reja Over a year ago

it's showing a error while..... DO $$ DECLARE x1 text = 'Hello'; x2 text = 'World'; BEGIN select x1; END; $$ LANGUAGE plpgsql;

Collectives™ on Stack Overflow

pgAdmin Create Variable [duplicate]

1 Answer 1

2 Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Linked

Related