Retool Database: CITEXT extension

[ghost-ap]

In the Retool Database, I'd like to add columns with the Postgres CITEXT type. I only see "TEXT" as an option for the underlying Pg type.

Is it possible to install the CITEXT extension to it?

[Toolshed]

Hey @ghost-ap

Yes, you can do this, but not directly through the Retool UI. You’ll first need to connect to your database using an IDE like Datagrip. Here's how:

1. In your Retool workspace, navigate to the Retool DB page.
2. Click the dropdown in the top-left corner and select Connection. (Only admins can access this section).
3. Copy the PSQL command and extract the connection details.
   -- Host: (from the PSQL command)
   -- Port: 5432
   -- User: retool
   -- Password: (from the PSQL command)
   -- Database name: retool
4. Once connected, run the following command: CREATE EXTENSION IF NOT EXISTS citext;
   

Please note that the Retool UI might still not recognize this extension. I recommend writing your DDL directly through your IDE as well.

Hope this helps,
Abdul Wasae
Toolshed - Hire Retool Developers