How To Declare Variable In PostgreSQL 9 Posted on by Webmaster IT Support Forum › Forums › Databases › PostgreSQL › SQL Queries › How To Declare Variable In PostgreSQL 9 Tagged: Variables This topic contains 0 replies, has 1 voice, and was last updated by Webmaster 2 years, 2 months ago. Author Posts September 14, 2016 at 10:49 am #1930 WebmasterKeymaster Declaring variables in PostgreSQL 9 is not as simple as with MSSQL. To declare a variable in PostgreSQL 9, you must use the following syntax: DO $$ DECLARE variableName TEXT := ‘value of variable’; BEGIN END $$; You can assign variables in PosgreSQL by simply typing the variables name, followed by := ???, where ??? is the value of the variable you want to set. Author Posts You must be logged in to reply to this topic.