Skip to content
🚀 Agentic Postgres: The first database built for agents 🤖
TimescaleDB - Timeseries database for PostgreSQL Docs
  • tigerdata.com
  • Try for free
Get started
Try the key Tiger Data features
Start coding with Tiger Data
Create a Tiger Cloud service
About Tiger Data products
Tiger Data architecture for real-time analytics
Pricing plans and account management
Feature comparison
Use Tiger Data products
Hypertables
Hypercore
Continuous aggregates
Tiger Cloud services
Write data
Query data
About querying data
SELECT data
Perform DISTINCT queries with SkipScan
Perform advanced analytic queries
Troubleshooting
Time buckets
Schema management
Configuration
Alerting
Data retention
Storage
Hyperfunctions
Metrics and logging
High availability and read scaling
Maintenance and upgrades
Tiger Cloud Postgres extensions
Back up and recover services
Fork services
Jobs
Security
Limitations
Integrate data lakes with Tiger Cloud
Troubleshoot Tiger Data products
Compression (Old API, replaced by hypercore)
Tutorials
Integrations
API Reference
Import and sync
Integrate AI with Tiger Data
Other deployment options
Find a docs page
Use Tiger Data products

Query data

Tiger Cloud: Performance, Scale, Enterprise, Free

Self-hosted products

MST

Hypertables in TimescaleDB are Postgres tables. That means you can query them with standard SQL commands.

  • About querying data
  • Select data with SELECT
  • Get faster DISTINCT queries with SkipScan
  • Perform advanced analytic queries

Keywords

queries

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

PreviousDelete dataNextAbout querying data

Related Content

SELECT data
Query data from a hypertable in TimescaleDB using the standard SELECT command
Get faster DISTINCT queries with SkipScan
Speed up DISTINCT queries by setting up a hypertable to take advantage of SkipScan
Troubleshooting queries
Suggestions for troubleshooting common problems in queries
About querying data
Querying data in TimescaleDB works just like querying data in Postgres, which means you can reuse your existing queries from another Postgres database
Perform advanced analytic queries
Perform real-time data analysis using native Postgres queries and TimescaleDB hyperfunctions
Jobs in TimescaleDB
Increase efficiency and reduce overhead by automating routine tasks. Set up custom jobs on top of TimescaleDB policies