The world's most advanced open source SQL database.

The world's most advanced open source SQL database. (updated: 1657720594436)

Artisan IMG > PostgreSQL (postgresql)

PostgreSQL (postgresql)

Counts the number of rows that meet a given set of conditions.

Conditions that the rows must meet to be returned. Note that for now, all conditions are AND.

Conditions

Database

Host name or IP address of the server to connect to

Host

Password

TCP port on which the server is listening

Port

The database schema. Usually "public" unless your database is set up to have multiple schemas.

Schema

SSL config

Table

User

count

Count rows

Conditions that the rows must meet to be returned. NOTE: 1) all conditions are AND. 2) 'contain', 'starts with' & 'ends with' conditions only work on values of datatype 'String'.

delete

Delete rows

Fields

Limit

Offset (skip)

find

Find rows

Rows to insert

insert

Insert new rows

list_table_fields_ddl

List table fields DDL

list_tables_ddl

List tables DDL

Execute the specified SQL code on the chosen database

The raw SQL query you'd like to run against the database. Note: you need to specify the schema (usually "public") here - it will not be automatically populated as with the other operations. Example: "SELECT * FROM public.user where id = $1"

SQL query

Values for SQL parameters you'd like to substitute into the query ($1, $2, etc.)

SQL Parameters

execute_sql

Run SQL query

Data that you'd like to update the row with.

Row data

update

Update rows

PostgreSQL 1.4

Fixed issue with authentication being override by schema defaults

PostgreSQL 1.5

Updated:
Find Rows
Update Rows
Delete Rows

PostgreSQL 2.2

The Postgres connector allows you to query your Postgres database directly within tray.io, without having to worry about data pipelines or servers.

PostgreSQL

Overview

Connecting to your Postgres instance

All Operations