Row Zero is now in public beta

Postgres to Spreadsheet

Import data directly from PostgreSQL to Row Zero.

Connect Row Zero to PostgreSQL

In Row Zero click on the 'data source' icon in the right-hand menu and then click the button for 'New data source.'PostgreSQL new data source screen in Row ZeroPostgreSQL add new connection screen in Row Zero

The connection requires 6 pieces of information defined below.

  1. Name - This field can be anything that helps identify the data source being connected. (e.g. "Production Data" or "Product Metrics")
  2. Host - This is the PostgreSQL address that typically takes the form of a string like 'database.mydomain.com'.
  3. Port - This is always 5432.
  4. User - This is the username for your PostgreSQL database.
  5. Password - The password used to log into your PostgreSQL Database.
  6. Database - The name of the PostgreSQL database being connected to.PostgreSQL creds name in Row Zero interface

Once all the information is entered, hit 'Test connection' to ensure the information is correct. If the test connection icon turns green and says 'Connected', proceed by clicking on '+ Add Source.'

Add PostgreSQL as source screen in Row Zero

Write a query to import data

Now that the Postgres database is connected to Row Zero, write a query to pull data into the spreadsheet. First select the 'Schema' from the drop down. Write a query in the query editor. The easiest query to write is the 'select *' statement, which pulls in the entire table. Example:

select * from TABLENAME

Row Zero is equipped to handle large data sets and will easily ingest the entirety of a table. Write more complicated queries to pull in various subsets of data stored in a Postgres Database. All results will be displayed in the connected data table in the spreadsheet.

Write PostgreSQL query in Row Zero

FAQs