Formsort
Search…
PostgreSQL
Send answers data to a PSQL database you run, or a hosted database like RDS.

Schema

Because the Formsort user should not have administrative permissions, you must create it yourself, using a SQL command.
Create a table named answer_set with the following command:
1
CREATE TABLE answer_set (
2
id SERIAL PRIMARY KEY,
3
submitted_at timestamp with time zone NOT NULL,
4
responder_uuid uuid NOT NULL,
5
flow_label character varying,
6
variant_label character varying,
7
variant_revision_uuid uuid,
8
event_type character varying,
9
answers jsonb,
10
schema_version smallint
11
);
12
CREATE UNIQUE INDEX answer_set_set_id_idx ON answer_set(id);
Copied!

Authentication

To allow Formsort to write to PostgreSQL, create a new user with insert permissions to the schema that contains your data table. You can then add the credentials for the user directly into Formsort.
Do not reuse a user with more permissions than are necessary to INSERT rows - Formsort does not even need SELECT access, and should not have any administrative permissions. Note: do grantUSAGE right on the sequence underpinning the primary key. Example using formsort role:
1
GRANT INSERT ON TABLE answer_set TO formsort;
2
GRANT USAGE ON SEQUENCE answer_set_id_seq TO formsort;
Copied!

Last modified 10mo ago
Copy link