Time-series data from PostgreSQL can be linked to Planhat's Companies, End Users, Assets or Projects as either Custom Metrics or User Activities in real-time. The connection supports auto-creation of End Users in Planhat, historical data syncing, and End User mapping with both Email and External ID.