= gerrit gsql

== NAME
gerrit gsql - Administrative interface to active database.

== SYNOPSIS
[verse]
--
_ssh_ -p <port> <host> _gerrit gsql_
  [--format {PRETTY | JSON | JSON_SINGLE}]
  [-c QUERY]
--

== DESCRIPTION
Provides interactive query support directly against the underlying
SQL database used by the host Gerrit server.  All SQL statements
are supported, including SELECT, UPDATE, INSERT, DELETE and ALTER.

== OPTIONS
--format::
	Set the format records are output in.  In PRETTY (the
	default) records are displayed in a tabular output suitable
	for reading by a human on a sufficiently wide terminal.
	In JSON mode records are output as JSON objects using the
	column names as the property names, one object per line.
	In JSON_SINGLE mode the whole result set is output as a
	single JSON object.

-c::
	Execute the single query statement supplied, and then exit.

== ACCESS
Caller must have been granted the
link:access-control.html#capability_accessDatabase[Access Database]
global capability.

== SCRIPTING
Intended for interactive use only, unless format is JSON, or
JSON_SINGLE.

== EXAMPLES
To manually correct a user's SSH user name:

----
$ ssh -p 29418 review.example.com gerrit gsql
Welcome to Gerrit Code Review v2.0.25
(PostgreSQL 8.3.8)

Type '\h' for help.  Type '\r' to clear the buffer.

gerrit> update accounts set ssh_user_name = 'alice' where account_id=1;
UPDATE 1; 1 ms
gerrit> \q
Bye

$ ssh -p 29418 review.example.com gerrit flush-caches --cache sshkeys --cache accounts
----

GERRIT
------
Part of link:index.html[Gerrit Code Review]

SEARCHBOX
---------
