> For the complete documentation index, see [llms.txt](https://doc.duaer.com/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://doc.duaer.com/build/postgres.md).

# Read and write Postgres in Duaer

In Duaer, Postgres defaults to Operation Insert. Choose Schema and Table, then map fields in Columns. You need a postgres credential.
## Insert a row

1. Create a postgres credential.
2. Search for Postgres, connect it after the previous node, and select that credential.
3. Leave Operation on Insert.
4. Choose Schema and Table.
5. Map input fields to table columns in Columns. Select Execute step.

On the current default version you also get Select, Update, Insert or Update, Delete, and Execute Query (raw SQL with $1, $2 parameters).

If field names do not match column names, rename them first with Edit Fields.

See also [Read and write MySQL in Duaer](/build/mysql.md) and [Find documents with MongoDB in Duaer](/build/mongodb.md).
## Questions

### Can Postgres in Duaer run a raw SQL statement?

Yes. Set Operation to Execute Query and write SQL in Query. Prefer query parameters to reduce injection risk.

## Related

- [Read and write MySQL in Duaer](https://doc.duaer.com/build/mysql.md)
- [Create an Airtable record in Duaer](https://doc.duaer.com/build/airtable.md)
- [Keep rows in a Duaer data table](https://doc.duaer.com/build/data-tables.md)