# Set default schema in PostgreSQL for Tag History tables to something other than public **URL:** \ **Category:** Ignition\ **Tags:** ignition81\ **Created:** [August 26, 2025, 5:30pm UTC](https://forum.inductiveautomation.com/t/set-default-schema-in-postgresql-for-tag-history-tables-to-something-other-than-public/110181 "2025-08-26T17:30:37Z")\ **Posts on this page:** 2\ **Page:** 1
**Author:** ![jeff.sagerer](https://avatars.discourse-cdn.com/v4/letter/j/a698b9/32.png) [@jeff.sagerer](https://forum.inductiveautomation.com/u/jeff.sagerer)\ **Post date:** [August 26, 2025, 5:30pm UTC](https://forum.inductiveautomation.com/t/set-default-schema-in-postgresql-for-tag-history-tables-to-something-other-than-public/110181/1 "2025-08-26T17:30:37Z")
How do I tell a tag history provider for a database connection which schema to use for creating the tag history tables and storing the tag history data? - Example database config for “pg\_ignition\_dev” - Connect URL: jdbc:postgresql://[hostname]/ignition-dev - Username: devuser - Extra Connection Properties: search\_path=historian - Tried this to set the historian schema as default but it did not work - Connection Initialization Commands: SET search\_path = 'historian'; - Also tried this but didn’t work - Example Tag History Provider - Nothing special here, just pointed it to the “pg\_ignition\_dev” config How do I change away from public? ---
**Author:** ![E.E.T](https://avatars.discourse-cdn.com/v4/letter/e/b19c9b/32.png) [@E.E.T](https://forum.inductiveautomation.com/u/E.E.T)\ **Post date:** [March 31, 2026, 8:48am UTC](https://forum.inductiveautomation.com/t/set-default-schema-in-postgresql-for-tag-history-tables-to-something-other-than-public/110181/2 "2026-03-31T08:48:02Z")
On your database connection properties add to your Extra Connection Properties field “currentSchema=yourSchemaName“ without quotes