title: TimescaleDB: Is it possible to call 'create_hypertable' from Python?
body: <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>