can you run a psql command line query?

#1

After reading the manual, it looks like you can run a query on a single
command line. But I cant get it to work...

Does this look right to anyone?

Quote:

psql -d hostname -c "update table set field='value'" -U username -W
password

maybe I dont have the syntax correct for parsing the string?

TIA,
tj

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

comp.databases.postgresql.general comp.databases.postgresql.general