Hi, suppose for a moment I want to write a psql script that loads some data into a database. I don't want to write an absolute path into my script, but merely know where the data file will be relative to my script location.
naiively, you might try: \set pwd '\'' `pwd` '\'' COPY table FROM :pwd || '/relative/path/to/data' ; but that doesn't work because the concatenation operator can't be used there. How should I be doing this? Thanks, Matthew -- Matthew Vernon Quantitative Veterinary Epidemiologist Epidemiology Research Unit, SAC Inverness -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
