commandlinefu.com is the place to record those command-line gems that you return to again and again.
You can sign-in using OpenID credentials, or register a traditional username and password.
Subscribe to the feed for:
alias for psql command line; works similar for Oracles sqlplus commandline interface.
if you do not provide stdin you will end up in the db shell.
There are 2 alternatives - vote for the best!
This is regarding the command 8263 using an alias to fill in command line options for psql.
You can actually just type 'psql'. In order for that to work, you want to set environment variables PGDATABASE, PGHOST, PGUSER, and (except you're using the default) PGPORT. Also, you can add a line "host:port:dbname:user:password" (asterisk ok in some columns) to your ~/.pgpass file. Finally, if you don't like the aligned columns, you can add the line "\pset format unaligned" to your ~/.psqlrc file.
If you can do better, submit your command here.
You must be signed in to comment.