Execute arbitrary SQL (-s)

Syntax: -s[X]

This option will cause gw to perform a SQL query against the database instead of retrieve pages. Place a quoted SQL statement on the command line instead of a URL. Only SELECT and DELETE statements are allowed and only one statement may be executed at a time. Do not include the trailing semi-colon (;).

Resultant rows will be formatted according to X where X is taken from the following table.

Format Styles

Style  Description
-----  --------------
  h    For an HTML table
  t    For tab separated values
  c    For comma separated values
  f    For tagged values. This is the default
  q    For no formatting

If X is not specified f is assumed.

e.g.:

gw -st "select Url,Title from html where Depth=0"

Also see Section 0.3.4 about what fields are in the database.