Skip to content
🐯 Timescale is now TigerData! Read the announcement from Ajay & Mike.
TimescaleDB - Timeseries database for PostgreSQL Docs
  • TigerData.com
  • Try for free
Get started
Try the key TigerData features
Start coding with TigerData
Create a Tiger Cloud service
About TigerData products
TigerData architecture for real-time analytics
Pricing plans and account management
Changelog
Use TigerData products
Hypertables
Hypercore
Continuous aggregates
Tiger Cloud regions
Tiger Cloud services
Control user access to Tiger Cloud projects
Write data
About writing data
Insert data
Update data
Upsert data
Delete data
Query data
Time buckets
Schema management
Configuration
Import and ingest data
Alerting
Data retention
Tiered storage
Hyperfunctions
Metrics and logging
High availability and read scaling
Maintenance and upgrades
Tiger Cloud PostgreSQL extensions
Backup, restore, and PITR
Jobs
Security
Limitations
Troubleshoot TigerData products
Compression (Old API, replaced by hypercore)
Tutorials
Integrations
API Reference
Migrate and sync data to Tiger Cloud
AI and Vector: pgai on Tiger Cloud
Other deployment options
Find a docs page
Use TigerCloud products

Write data

Tiger Cloud: Performance, Scale, Enterprise

Self-hosted products

MST

Writing data in TimescaleDB works the same way as writing data to regular PostgreSQL. You can add and modify data in both regular tables and hypertables using INSERT, UPDATE, and DELETE statements.

  • Learn about writing data in TimescaleDB
  • Insert data into hypertables
  • Update data in hypertables
  • Upsert data into hypertables
  • Delete data from hypertables

For more information about using third-party tools to write data into TimescaleDB, see the Ingest data from other sources section.

Keywords

ingest

Found an issue on this page?Report an issue or Edit this page in GitHub.

PreviousControl user access to Tiger Cloud projectsNextAbout writing data

Related Content

Insert data
Insert single and multiple rows and return data in TimescaleDB with SQL
About writing data
Writing data in TimescaleDB works the same way as writing data to regular PostgreSQL tables. Learn the basics of inserting, updating, upserting, and deleting data in your database using SQL
Delete data
Delete data with DELETE or by dropping chunks from a hypertable in your database using SQL
Update data
Update single and multiple rows in a hypertable in your TimescaleDB database with SQL
Upsert data
Insert a new row or update an existing row in a hypertable using UPSERT
Jobs in TimescaleDB
Increase efficiency and reduce overhead by automating routine tasks. Set up custom jobs on top of TimescaleDB policies