= gsql

== NAME
gsql - Administrative interface to idle database

== SYNOPSIS
--
'java' -jar gerrit.war 'gsql' -d <SITE_PATH>
--

== DESCRIPTION
Interactive query support against the configured SQL database.
All SQL statements are supported, including SELECT, UPDATE, INSERT,
DELETE and ALTER.

This command is primarily intended to access a local H2 database
which is not currently open by a Gerrit daemon.  To access an open
database use link:cmd-gsql.html[gerrit gsql] over SSH.

== OPTIONS

-d::
--site-path::
	Location of the gerrit.config file, and all other per-site
	configuration data, supporting libraries and log files.

== CONTEXT
This command can only be run on a server which has direct
connectivity to the metadata database, and local access to the
managed Git repositories.

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

====
	$ java -jar gerrit.war 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
====

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

SEARCHBOX
---------