TimescaleDB: Is it possible to call 'create_hypertable' from Python? : <p>I want to create TimescaleDB tables in Postgres on the fly as I'm dealing with data sources that change (financial feeds, so could be 100, could be 1000) over time and I want one table per data source.</p>

<p>I can create the tables no problem from Python, but when I call <code>SELECT create_hypertable(test_table1, time)</code> it throws an error. The same query seems to work fine when executed from pSQL of course, so it looks like the timescale API isn't available via psycopg2 perhaps?</p>

<h2>Environment:</h2>

<ul>
<li>Python 3.6.4</li>
<li>psycopg2-binary-2.7.4 (installed with the flag: --no-binary :all:)</li>
<li>Postgres: 10.3</li>
<li>Timescaledb: 0.8.0-2</li>
<li>MacOS: 10.13.3</li>
</ul>

<h2>Test Code:</h2>

<pre><code>db.query("CREATE TABLE test_table1 (time TIMESTAMP NOT NULL, name CHAR(100) NOT NULL")
db.query("SELECT create_hypertable('test_table1', 'time')")
</code></pre>

<h2>Error:</h2>

<blockquote>
  <p>2018-03-05 11:45:36,901 [MainThread  ] [ERROR]  function create_hypertable(unknown, unknown) does not exist<br/>
  LINE 1: SELECT create_hypertable('temp_table1', 'time')<br/>
  . . . . . . . . . . . . . . ^<br/>
  HINT:  No function matches the given name and argument types. You might need to add explicit type casts.</p>
</blockquote>

<p>Does anyone know if there currently anyway to making this work? Have I missed something simple? Or is there another service that can replace timescale functionality that supports being dynamically created?</p>
