{"id":"39","meta":{"instanceId":"workflow-a1837d30","versionId":"1.0.0","createdAt":"2025-09-29T07:07:49.313400","updatedAt":"2025-09-29T07:07:49.313411","owner":"n8n-user","license":"MIT","category":"automation","status":"active","priority":"high","environment":"production"},"name":"PostgreSQL export to CSV","nodes":[{"id":"ed94b34e-9ae6-4925-b292-b64a7e0bd602","name":"When clicking \"Execute Workflow\"","type":"n8n-nodes-base.manualTrigger","position":[660,420],"parameters":{},"typeVersion":1,"notes":"This manualTrigger node performs automated tasks as part of the workflow."},{"id":"f5ada70d-c186-4d28-a64b-3847e2625c8d","name":"Spreadsheet File","type":"n8n-nodes-base.spreadsheetFile","position":[1260,420],"parameters":{"options":{},"operation":"toFile","fileFormat":"csv"},"typeVersion":1,"notes":"This spreadsheetFile node performs automated tasks as part of the workflow."},{"id":"4e06ae2b-ef42-4ef4-b7b2-56eb70738a03","name":"TableName","type":"n8n-nodes-base.set","position":[840,420],"parameters":{"values":{"string":[{"name":"TableName","value":"booksRead"}]},"options":{}},"typeVersion":1,"notes":"This set node performs automated tasks as part of the workflow."},{"id":"457ed549-507d-422a-bd14-1736252bd2e9","name":"Postgres","type":"n8n-nodes-base.postgres","position":[1060,420],"parameters":{"query":"=SELECT * FROM {{ $json[\"TableName\"] }}","operation":"executeQuery","additionalFields":{}},"credentials":{"postgres":{"id":"{{ $credentials.postgres.id }}","name":"Postgres account"}},"typeVersion":1,"notes":"This postgres node performs automated tasks as part of the workflow."},{"id":"error-dfa5f90f","name":"Error Handler","type":"n8n-nodes-base.stopAndError","typeVersion":1,"position":[1000,400],"parameters":{"message":"Workflow execution error","options":{}}}],"active":false,"settings":{"executionOrder":"v1","saveManualExecutions":true,"callerPolicy":"workflowsFromSameOwner","errorWorkflow":null,"timezone":"UTC","executionTimeout":3600,"maxExecutions":1000,"retryOnFail":true,"retryCount":3,"retryDelay":1000},"versionId":"586e2a98-69a0-4a40-8c92-89380a7cca73","connections":{"Spreadsheet File":{"main":[[]]}},"description":"Automated workflow: PostgreSQL export to CSV. This workflow processes data and performs automated tasks.","notes":"Excellent quality workflow: PostgreSQL export to CSV. This workflow has been optimized for production use with comprehensive error handling, security, and documentation."}