0

I am running citus PostgreSQL build from here:

https://github.com/citusdata/docker/blob/master/docker-compose.yml

But I don't know how to check whether the instance has the cstore foreign data wrapper available for columnar support? I'm guessing there's a way to do it from psql much like HSTORE?

David Watson
  • 3,394
  • 2
  • 36
  • 51
  • 3
    `pg_available_extensions` and `pg_extensions` ? – Craig Ringer Mar 17 '17 at 05:05
  • You can query the catalog tables, like Craig suggested, or just run the `create extension` command & see what happens. There is also a [FDW, which can list other FDWs](https://github.com/daamien/fdw_fdw), but if want to find out that this FDW is available or not, that will be tricky (if not philosophical) – pozs Mar 17 '17 at 09:08
  • If one of you want to make that an answer, I'll mark it answered. Thanks! – David Watson Mar 29 '17 at 19:24

0 Answers0