Search Postgresql Archives

Re: Query generator

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



Vinicius Segalin <vinisegalin@xxxxxxxxx> writes:

> 2016-09-29 16:32 GMT-03:00 Julien Rouhaud <julien.rouhaud@xxxxxxxxxx>:
>
> >  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?

It should pick your relations with the same likelihood it picks the
catalog tables.  You could verify this for with, e.g.,

    sqlsmith --dry-run | grep your_table_name

Thanks to Julien, sqlsmith's master branch now has an option
--exclude-catalog that inhibits use of catalog relations.  If you are
building from github, you might want to give it another chance with this
option.  I'll probably do a proper release in next two weeks.

Feedback welcome :-)

regards,
Andreas


-- 
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general



[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux