[commands] show help on backslash commands \? options show help on psql command-line options \? variables show help on special variables \h [NAME] help on syntax of SQL commands, * for all commandsQuery Buffer \e [FILE] [LINE] edit the query buffer (or file) with...
\g [(OPTIONS)] [FILE] execute query (and send result to file or |pipe); \g with no arguments is equivalent to a semicolon \gdesc describe result of query, without executing it \gexec execute query, then execute each value in its result \gset [PREFIX] execute query and store result...
\errverbose show most recent error message at maximum verbosity \g[(OPTIONS)][FILE]execute query(and send result to file or|pipe);\g with no arguments is equivalent to a semicolon \gdesc describe result of query,without executing it \gexec execute query,then execute each valueinits result...
General \copyright show PostgreSQL usage and distribution terms \crosstabview [COLUMNS] execute query and display result in crosstab \errverbose show most recent error message at maximum verbosity \g [(OPTIONS)] [FILE] execute query (and send result to file or |pipe); \g with no arguments is...
\g with no arguments is equivalent to a semicolon \gdesc describe result of query, without executing it \gexec execute query, then execute each value in its result \gset [PREFIX] execute query and store result in psql variables \gx [(OPTIONS)] [FILE] as \g, but forces expanded output...
\g with no arguments is equivalent to a semicolon \gdesc describe result of query, without executing it \gexec execute query,thenexecute each valueinits result \gset [PREFIX] execute query and store resultinpsql variables \gx [(OPTIONS)] [FILE] as \g, but forces expanded output mode ...
Learn to exit PostgreSQL's command-line interface, psql, ensuring a smooth closure of your database sessions in this straightforward tutorial.
In general, when you connect to a database server using any database command line client tool, you run two types of commands on the CLI: Commands processed by the database CLI client locally, often known asmeta commands. These commands help to perform the following: ...
More about command line arguments of psql in the manual. Share Improve this answer Follow edited Nov 9, 2023 at 8:02 answered Jun 17, 2012 at 3:30 Erwin Brandstetter 180k2828 gold badges451451 silver badges612612 bronze badges Add a comment 7 To add another functionality for -v...
Having access to the psql command-line tool is essential for any developers or DBAs that are actively working with and connecting to PostgreSQL databases. In our first article, we discussed the brief history of psql and demonstrated how to install it on your platform of choice and connect...