I had the same problem, but it was fixed by running following code
CREATE EXTENSION postgis;
In detail,
- open pgAdmin
- select (click) your database
- click "SQL" icon on the bar
- run "CREATE EXTENSION postgis;" code
Hi, To get column names only select column_name from information_schema.columns where table_name='captor_prime_aggregates'; Thanks Sreelatha