term1 Definition1term2 Definition2term3 Definition3
Please sign in to your Google account to access your documents:
What is psql? What is edb-psql? What are the differences between them?
psql is a terminal-based front-end to Postgres. edb-psql is identical to psql
What file is executed every time psql/edb-psql starts? When is it not run?
$HOME/.psqlrc
Unless option -X is specified
What are the minimum command line parameters required to run psql/edb-psql?
-d, --dbname=, $PGDATABASE
-h, --host=, $PGHOST
-p, --port=, $PGPORT
-U, --username=, $PGUSER
How do you make psql/edb-psql execute the commands in a file then exit?
-f FILENAME
How do you make psql/edb-psql execute a command then exit?
-c COMMAND
How do you show the psql/edb-psql command history? How do you save it to a file?
\s - show the command history
\s FILENAME- save the command history to a file
How do you edit the psql/edb-psql query buffer then execute it?
\e
How do you edit a psql/edb-psql file then execute it?
\e FILENAME
How do you save the psql/edb-psql buffer to a file?
\w FILENAME
In psql/edb-psql how do you save all query results and output to a file?
-o filename
\o filename
\out filename
Need help typing ? See our FAQ (opens in new window)
Please sign in to create this set. We'll bring you back here when you are done.
Discard Changes Sign in
Please sign in to add to folders.
Sign in
Don't have an account? Sign Up »
You have created 2 folders. Please upgrade to Cram Premium to create hundreds of folders!