Re: Psql syntax run within java code

I don't know how old this message is, but looks like it needs a username to connect as? Just try

psql -d car -U username -c 'select id from pegs1';

There was also a post yesterday about being able to put the pass in a .pgpass file, if it would fail for lack of a password

> strQueryForExportDump = "psql -d car -c 'select id from pegs1' ";
> This is the output I see from the log:
>
> dump str is psql -d car -c 'select id from pegs1;'
> cmd out1 is
> err stream is psql: warning: extra command-line argument "from" ignored
> psql: warning: extra command-line argument "pegs1;'" ignored
> psql: FATAL: user "id" does not exist
>
> Please help.
>
> Peggy
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 2: you can get off all lists at once with the unregister command
> (send "unregister YourEmailAddressHere" to majordomo(at)postgresql(dot)org)

--
joe speigle
www.sirfsup.com