Re: Query generator - Mailing list pgsql-general

From Vinicius Segalin
Subject Re: Query generator
Date
Msg-id CAAeH1nCaSSJLWumfW5+PLd8vMNXkKf2RoV_gWKAjjb=F9etu_A@mail.gmail.com
Whole thread Raw
In response to Re: Query generator  (Julien Rouhaud <julien.rouhaud@dalibo.com>)
Responses Re: Query generator  (Julien Rouhaud <julien.rouhaud@dalibo.com>)
Re: Query generator  (Andreas Seltenreich <seltenreich@gmx.de>)
List pgsql-general
2016-09-29 16:32 GMT-03:00 Julien Rouhaud <julien.rouhaud@dalibo.com>:
On 29/09/2016 21:27, Vinicius Segalin wrote:
> Hi everyone,
>

Hello,

> Does anyone know a random query generator for Postgres? Something that
> gets my schema and, based on that, generates hundreds of different
> queries with join, group by, etc.
>

You should try sqlsmith (https://github.com/anse1/sqlsmith), which works
very well.

I had found this one before, but all I could get was queries using "standard" tables, like the ones from pg_catalog and information_schema. It didn't generate queries from the tables I've created. Was I doing something wrong?

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: pg_upgrade from 9.5 to 9.6 fails with "invalid argument"
Next
From: Venkata B Nagothi
Date:
Subject: Re: Multi tenancy : schema vs databases