CREATE EXTENSION rotfang_fdw; CREATE FUNCTION random_tstz (typmod int) RETURNS timestamptz LANGUAGE SQL as $$ SELECT now() - (random() * 20.0) * interval '1 year' $$; CREATE FOREIGN TABLE rand2 (b boolean, ts timestamptz) SERVER rotfang OPTIONS (maxrows '10', func_ts 'random_tstz'); SELECT * FROM rand2;
Friday, June 19, 2015
Rotfang, the random data generator
The other day I gave a lightning talk at pgCon about a Foreign Data Wrapper called Rotfang, which is for generating arbitrary amounts of random data. This is intended for generating test cases. The software supports a small number of data types natively, but also allows you to use user-supplied functions to generate data. It's available on bitbucket. A short example:
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment