/* PostgreSQL: test cdecimal and decimal.py performance with
   the NUMERIC type. */


CREATE DATABASE dectest;
\connect dectest;


CREATE ROLE decuser;
ALTER ROLE decuser PASSWORD 'changeme';
ALTER ROLE decuser LOGIN;

CREATE SEQUENCE numeric_table_seq;
CREATE TABLE numeric_table (
	id	integer default nextval('numeric_table_seq'),
	a	NUMERIC(10, 2),
	b	NUMERIC(5, 2),
	c	NUMERIC(20, 7),
	d	NUMERIC(15, 4)
);
GRANT SELECT,INSERT,UPDATE,DELETE ON numeric_table TO decuser;
GRANT SELECT,UPDATE ON numeric_table_seq TO decuser;



