Run A Sql Query On Postgres

About This Script

Features:

• Automates workflow tasks
• Ready to import into n8n
• Configurable parameters

{
    "nodes": [
        {
            "name": "On clicking 'execute'",
            "type": "n8n-nodes-base.manualTrigger",
            "position": [
                250,
                300
            ],
            "parameters": [],
            "typeVersion": 1,
            "id": "e31c1f59-cdde-4236-9a33-72bc157b3c0c"
        },
        {
            "name": "Postgres",
            "type": "n8n-nodes-base.postgres",
            "position": [
                450,
                300
            ],
            "parameters": {
                "query": "SELECT * from sometable;",
                "operation": "executeQuery"
            },
            "credentials": {
                "postgres": "postgres-creds"
            },
            "typeVersion": 1,
            "id": "1a011bb6-7a6f-4691-b9be-f074a56ba4f6"
        }
    ],
    "connections": {
        "On clicking 'execute'": {
            "main": [
                [
                    {
                        "node": "Postgres",
                        "type": "main",
                        "index": 0
                    }
                ]
            ]
        }
    },
    "n8n_version": "1.5.0"
}

Requirements