GreenPlum の毎日の SQL スクリプト

SELECT EXTRACT(DAY FROM CAST('2017-08-01' AS DATE) + INTERVAL '1 month' - INTERVAL '1 day')

SELECT EXTRACT(DAY FROM CAST(TO_CHAR(NOW(),'YYYY-MM')||'-01' AS DATE) + INTERVAL '1 month' - INTERVAL '1 day')

SHOW search_path;
SET search_path TO your_schema_name;

ALTER SCHEMA your_schema_name OWNER TO other_user;

ALTER TABLE your_table_name OWNER TO other_user;

GRANT SELECT ON TABLE your_table_name TO other_user;
GRANT ALL ON TABLE your_table_name TO other_user;

GRANT USAGE ON SCHEMA your_schema_name TO other_user;

REVOKE ALL ON SCHEMA your_schema_name FROM other_user;