---
name: "query"
section: "1"
platform: "linux"
package: "sqlrelay"
version: "1:0.39.4-6"
release: "Debian 5.0 (Lenny)"
platforms: ["linux"]
url: "https://new.carta.tech/query"
---

# query(1)

execute a query

## NAME

query - execute a query

## SYNOPSIS

**query** *host port socket user passwd query* \[debug\]\
 **query** \[-config *configfile*\] -id *id query* \[debug\]

## DESCRIPTION

The **query** command executes the query specified in the *query* parameter and returns the result set as a quote/comma/return seperated value list to standard output.

## OPTIONS

- *host*

  hostname of the machine running the listener daemon

- *port*

  port number the listener daemon is listening on, for local or remote connections

- *socket*

  socket the listener daemon is listening on, for local connections

- *user*

  SQL Relay user name (as per config file)

- *passwd*

  SQL Relay password (as per config file)

- **-config** *configfile*

  config file to use (default /etc/sqlrelay/sqlrelay.conf)

- **-id** *id*

  instance to use (as per config file)

- *query*

  query to be executed

- **debug**

  produce debugging output

## EXAMPLES

- **query "" "" /tmp/examplesocket fred secret "select \* from tbl"**

  Connect to the SQL Relay listener daemon running on the local machine, with socket **/tmp/examplesocket**, as user **fred**, with password **secret**, and run a query.

- **query dbsvr 9000 "" fred secret "select \* from tbl" debug**

  Connect to the SQL Relay listener daemon running on the remote machine **dbsvr**, on port **9000**, as user **fred**, with password **secret**, and run a query, producing extra debugging output.

- **query -id example "select \* from tbl"**

  Connect to the SQL Relay listener daemon for instance **example** (as defined in /etc/sqlrelay/sqlrelay.config), and run a query.

## SEE ALSO

[**fields**(1)](/fields/1.md),

[**sqlr-config-gtk**(1)](/sqlr-config-gtk/1.md), [**sqlrsh**(1)](/sqlrsh/1.md), [**sqlr-cachemanager**(8)](/sqlr-cachemanager/8.md), [**sqlr-connection**(8)](/sqlr-connection/8.md), [**sqlr-listener**(8)](/sqlr-listener/8.md), [**sqlr-scaler**(8)](/sqlr-scaler/8.md), [**sqlr-start**(8)](/sqlr-start/8.md), [**sqlr-stop**(8)](/sqlr-stop/8.md), and the documentation in /usr/share/doc/sqlrelay.

## AUTHORS

This manual page was written by Andreas Tille \<tille@debian.org\> and Florian M. Weps \<fweps@pop.agri.ch\>, for the Debian GNU/Linux system (but may be used by others).