Re: SQL Path in psql - Mailing list pgsql-general

From BladeOfLight16
Subject Re: SQL Path in psql
Date
Msg-id CA+=1U=UXOSzoA7qTmvMYnj=CiscNsJ34b3oaE958OTBM2qERHQ@mail.gmail.com
Whole thread Raw
In response to Re: SQL Path in psql  (David Kerr <dmk@mr-paradox.net>)
List pgsql-general
On Fri, Sep 6, 2013 at 1:58 PM, David Kerr <dmk@mr-paradox.net> wrote:
I suspect this feature makes more sense on a windows platform. On linux where we can
go psql -f ${SQLPATH}/file.sql . it becomes less pressing. Even Oracle
on unix/linux where you can go sqlplus <<EOD @${SQLPATH}/file.sql EOD. makes
it less a requirement.

I don't see why you couldn't do the same thing in command prompt on Windows:

SET PGSQLPATH=C:\somedir
psql -f %PGSQLPATH%\file.sql

Naturally, you could configure a permanent environment variable instead of using SET.

pgsql-general by date:

Previous
From: Rob Sargentg
Date:
Subject: Re: Sum of columns
Next
From: Jayadevan M
Date:
Subject: Re: [pgeu-general] Call for design: PostgreSQL mugs