Passing Parameters To Command Scripts

From: "Duncan Garland" <duncan(dot)garland(at)ntlworld(dot)com>
To: <pgsql-novice(at)postgresql(dot)org>
Subject: Passing Parameters To Command Scripts
Date: 2006-11-15 14:56:23
Message-ID: MBEPKEEDMKGCDODFKLPPGECHDEAA.duncan.garland@ntlworld.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

I'm in the process of converting some Oracle SQL scripts to Postgres. Many
of the scripts accept arguments along the following
lines:

@tmp.sql fred

I can't find the Postgres equivalent.

This works from outside Postgres:

psql -f tmp.sql -v arg1=fred

This works from within psql

\set arg1 fred
\i tmp.sql
\unset arg1

But the following all fail

\i tmp.sql fred
\i tmp.sql arg1=fred
\i tmp.sql -v arg1=fred

Can anyone help? What is the correct syntax?

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Richard Broersma Jr 2006-11-15 15:24:57 Re: Passing Parameters To Command Scripts
Previous Message Richard Broersma Jr 2006-11-15 01:45:42 Re: hardware - generic