Odd psql \i behaviour

Lists: pgsql-hackers
From: "Christopher Kings-Lynne" <chriskl(at)familyhealth(dot)com(dot)au>
To: "Hackers" <pgsql-hackers(at)postgresql(dot)org>
Subject: Odd psql \i behaviour
Date: 2002-04-03 05:45:13
Message-ID: GNELIHDDFBOCMGBFGEFOIEPBCBAA.chriskl@familyhealth.com.au
Views: Raw Message | Whole Thread | Download mbox | Resend email
Lists: pgsql-hackers

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


From: Peter Eisentraut <peter_e(at)gmx(dot)net>
To: Christopher Kings-Lynne <chriskl(at)familyhealth(dot)com(dot)au>
Cc: Hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: Odd psql \i behaviour
Date: 2002-04-03 16:25:39
Message-ID: Pine.LNX.4.30.0204031120530.684-100000@peter.localdomain
Views: Raw Message | Whole Thread | Download mbox | Resend email
Lists: pgsql-hackers

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(at)gmx(dot)net