Breaks toolbelt pg:psql features

[msakrejda]

Because this plugin redefines the pg:psql command, features like -c and the app::COLOR prompt don't work if the plugin is installed:

maciek@gamera:~$ heroku pg:psql maroon --app db-corral
---> Connecting to HEROKU_POSTGRESQL_MAROON_URL
Pager usage is off.
psql (9.3.3, server 9.3.2)
SSL connection (cipher: DHE-RSA-AES256-SHA, bits: 256)
Type "help" for help.

db-corral::MAROON=> \q
maciek@gamera:~$ heroku pg:psql -c "select 1" maroon --app db-corral
---> Connecting to HEROKU_POSTGRESQL_MAROON_URL
 ?column? 
----------
        1
(1 row)
maciek@gamera:~$ heroku plugins:install https://github.com/heroku/heroku-pg-extras
Installing heroku-pg-extras... done
maciek@gamera:~$ heroku pg:psql maroon --app db-corral
Pager usage is off.
psql (9.3.3, server 9.3.2)
SSL connection (cipher: DHE-RSA-AES256-SHA, bits: 256)
Type "help" for help.

d7sae5lh1fgjii=>

maciek@gamera:~$ heroku pg:psql -c "select 1" maroon --app db-corral
Pager usage is off.
psql (9.3.3, server 9.3.2)
SSL connection (cipher: DHE-RSA-AES256-SHA, bits: 256)
Type "help" for help.

d7sae5lh1fgjii=> 

[jaredbeck]

Jon Mountjoy has described a work-around to this problem using echo.

[will]

~ ➤ heroku pg:psql -a will <<< 'select 1'
 ?column?
----------
        1
(1 row)

Time: 73.745 ms

that has worked forever, I'm not sure why Ed added the -c thing since it's
redundant. I think I remember arguing against it being added and lost but I
don't remember why

On Mon, May 5, 2014 at 3:07 PM, Jared Beck notifications@github.com wrote:

Jon Mountjoy http://stackoverflow.com/users/247451/jon-mountjoy has
described a work-aroundhttp://stackoverflow.com/questions/23063270/how-to-pass-cli-options-to-heroku-pgpsqlto this problem using
echo.

—
Reply to this email directly or view it on GitHubhttps://github.com//issues/71#issuecomment-42232468
.

[msakrejda]

psql itself supports -c, and without the rather obscure here string syntax, feeding psql (and heroku pg:psql) from standard in is awkward. Regardless of that, shadowing breaks app::COLOR prompts and any future flags / checks the Heroku CLI may add.

[will]

This is fixed by #96

[will]

fixed