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