Authorization of a PostgreSQL Account
The first time you add a PostgreSQL card to a FLO, you will need to create a configuration. This will allow you to connect to your account, save your account information, and reuse that configuration next time you build a FLO with the connector. That way, you don’t have to sign in every time you want to build a FLO with this Connector. Instead, use the configuration you have already set up. You can create and save multiple configurations and share them with your teammates.
Here’s how to set up a new configuration in PostgreSQL:
- Enter in an Account Nickname. This should be unique so if you are connecting multiple PostgreSQL accounts you will be able to tell them apart (e.g. “Postgres 1”).
- Enter your PostgreSQL Username and Password.
- Enter the Database Host, the server that hosts your database (e.g. “stampy.db.elephantsql.com”). Do not include the protocol or port.
- Enter your Database Name, the unique name of your database on the server.
- Enter the Database Port, the port that your database can be accessed at. The default port for PostgreSQL is ”5432”. You can find your port in the URL used to access your database after the hostname (e.g. “postgres://[username]:[password]@[hostname]:5432/[database name]“).
- Click Create to finish this configuration.
- Build Row Object - Build a record that you can insert into your database
- Create Multiple Rows - Insert many records into your database
- Create Row - Insert a single row into your database
- Delete Rows - Remove data from your database
- Execute Query - Execute a raw SQL query against a database
- Import from CSV
- Query Rows - Read records from your database
- Read Table - Read schema information about a table
- Update Rows - Update records in your database