[SQL] how to concatenate in PostgreSQL

[Rehan Saleem]

hi ,
how can we concatinate these lines and execute sql command
 
       setsql ='select user,username,
firstname '
      set sql +=' lastname, cardno from table1where userid='+ 5 
      exec(sqi) 
     where 5 is the userid from table1
thanks