---
name: "query.py"
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.py"
---

# query.py(1)

execute a query

## NAME

query.py - execute a query

## SYNOPSIS

**query** *host port socket user passwd query*

## DESCRIPTION

The **query.py** 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)

- *query*

  query to be executed

  This command is a python implementation of the **query** (1) command.

## EXAMPLES

- **query.py "" "" /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.

## SEE ALSO

[**fields**(1)](/fields/1.md), [**query**(1)](/query/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@greenmail.ch\>, for the Debian GNU/Linux system (but may be used by others).