Thread: " \i filename "

In psql,  does the   " \i filename "  allow you to choose a file not
in the current directory.?  It seems that \i only allows you to
specify a filename which is in your current directory; the one you
are in before you start psql.

Thanks.

>>>>> "s" == sim  <sim@infomatch.com> writes:

  s> In psql,  does the   " \i filename "  allow you to choose a file not
  s> in the current directory.?  It seems that \i only allows you to
  s> specify a filename which is in your current directory; the one you
  s> are in before you start psql.

Just say `\i /absolute/path/to/file.sql', or use a relative pathname.

--
Eric Marsden
emarsden @ mail.dotcom.fr
It's elephants all the way down

> To:            sim@infomatch.com
> Cc:            pgsql-general@postgreSQL.org
> Subject:       Re: [GENERAL] " \i filename "
> Reply-to:      emarsden@mail.dotcom.fr
> From:          Eric Marsden <emarsden@mail.dotcom.fr>
> Date:          11 Sep 1998 11:52:11 +0200

> >>>>> "s" == sim  <sim@infomatch.com> writes:
>
>   s> In psql,  does the   " \i filename "  allow you to choose a file not
>   s> in the current directory.?  It seems that \i only allows you to
>   s> specify a filename which is in your current directory; the one you
>   s> are in before you start psql.
>
> Just say `\i /absolute/path/to/file.sql', or use a relative pathname.
>

Thanks a lot. But I still have problems using absolute path names or
even relative path names. I have set up the $PATH also, but it did
not help.

Thanks.