What's with this?

current pwd = /home/chriskl

usa=# \i ddlpack/kl_setnotnull.sql   <-- tab completes properly
DROP
CREATE
usa=# \i ~/ddlpack/kl_setnotnull.sql   <-- tab completes properly
~/ddlpack/kl_setnotnull.sql: No such file or directory
usa=#

Chris


Wed, 3 Apr 2002 13:45:13 +0800
"Christopher Kings-Lynne" <chriskl@familyhealth.com.au>
Odd psql \i behaviour
Christopher Kings-Lynne writes:

> usa=# \i ~/ddlpack/kl_setnotnull.sql   <-- tab completes properly
> ~/ddlpack/kl_setnotnull.sql: No such file or directory

The tilde is only meaningful in bash (or some other shell).

Try putting this in your .inputrc:

$if psql
set expand-tilde on
$endif

That will expand the tilde when you press TAB.

-- 
Peter Eisentraut   peter_e@gmx.net


Wed, 3 Apr 2002 11:25:39 -0500 (EST)
Peter Eisentraut <peter_e@gmx.net>
Re: Odd psql \i behaviour