Variable + string concatenation?

From: Francisco Reyes <lists(at)natserv(dot)com>
To: Pgsql Novice <pgsql-novice(at)postgresql(dot)org>
Subject: Variable + string concatenation?
Date: 2001-12-21 22:00:24
Message-ID: 20011221165506.L10480-100000@zoraida.natserv.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

How can I concatenate a variable to a string?
Something like:

\set input_directory /dsk2/pg_input/
concatenate input_directory + "filename"

copy horses from :input_directory 'horses.txt' with NULL as '';

I am going to have the "\set" in a file which I am going to "\i" include
into several scripts. This way i would be able to easily change the source
directory for all scripts.

Browse pgsql-novice by date

  From Date Subject
Next Message Vijay Deval 2001-12-22 11:32:01 Re: Import DB from DOS- dbase4
Previous Message Frank Hilliard 2001-12-21 21:47:38 phpPgAdmin Security hole