asmuth / clip

Create charts from the command line
https://clip-lang.org
Apache License 2.0
5.15k stars 387 forks source link

Cannot import postgresql table #231

Closed gigablah closed 5 years ago

gigablah commented 8 years ago

After compiling postgresql support, I still cannot get data from an external pg database.

2015-09-17 08:18:05 [DEBUG] HTTP request: POST /query
2015-09-17 08:18:05 [DEBUG] Executing ChartSQL query: IMPORT TABLE data FROM 'postgres://database_host:5432/database?user=user&pass=pass';
SELECT * FROM data;
2015-09-17 08:18:05 [DEBUG] Executing Postgres query
2015-09-17 08:18:05 [DEBUG] -- query: SELECT FROM data

As you can see the actual query ends up as SELECT FROM data, which returns only the rowcount.