Re: [SQL] Query from shell

[Bricklen Anderson]

Owen Jacobson wrote:

Judith wrote:

Hi every body, somebody can show me hot to execute a query from a shell

echo QUERY HERE | psql databasename

Or, if you want to run several queries, run psql and run your queries there.

or
psql -d <dbname> -c "your query here"

---------------------------(end of broadcast)---------------------------
TIP 5: don't forget to increase your free space map settings