Am Donnerstag, 19. August 2004 15:39 schrieb Fuchs Clemens: > Now I want to concatenate a variable value with a "hardcoded" value in my > script - something like: > > CREATE TABLE :myValue + _the_hardcoded_string ......
Option 1: \set tmp :myValue 'hardcoded' CREATE TABLE :tmp ... Option 2: CREATE TABLE :myValue "hardcoded" ... If myValue is double quoted, then the values will automatically be concatenated by the backend parser, but for strange (SQL-standard) reasons you need a line break in between. -- Peter Eisentraut http://developer.postgresql.org/~petere/ ---------------------------(end of broadcast)--------------------------- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faqs/FAQ.html
