Question: pgsql how to declare variable?
Answer: First, specify the name of the variable. ...  Second, associate a specific data type with the variable. ...  Third, optionally assign a default value to a variable.