In the left-hand panel, click and select Managed Service for PostgreSQL.
In the top-right corner, click Create cluster.
Configure the cluster:
Under Basic parameters, fill in the Cluster name field. The name may contain uppercase and lowercase Latin letters, numbers, underscores, and hyphens.
Under Database, fill in the DB name and Username fields. The names may contain uppercase and lowercase Latin letters, numbers, underscores, and hyphens.
Under Database, fill in the Password field.
Under Database, set the Locale for sorting (LC_COLLATE) and Charset locale (LC_CTYPE) fields to en_US.UTF8. Once you create a database, you cannot change these parameters.
Under Additional settings, enable Access from the management console and Serverless access.
Configure other parameters if needed. For more information, see {#T}.
Click Create cluster.
Wait until the new cluster's Availability field changes to Alive.
Step 2. Create a table
Go to the page of the created cluster.
In the left-hand panel, click SQL.
Select the appropriate username and database, enter the password, and click Connect.
Select the public schema.
Run the following query in the SQL editor:
create table answers(
id serial primary key,
answer jsonb,
created timestampwithtime zone default now()
);
In the top panel on the account page, click Create new key → Create API key.
Provide a brief description for the key.
Click Create.
This will open a window with the key ID and the secret key. Store them in a secure place. You will not be able to access them after you close the window.