Nina
Reputation: 548
Can Npgsql read from PostgreSQL columnar store?
To use columnar store extension of PostgreSQL, foreign tables are created... Can Npgsql read from such tables? If yes, is it similar to reading from traditional tables?
Upvotes: 0
Views: 58
Answers (1)
Laurenz Albe
Reputation: 246788
Yes, that should work fine.
No matter what the foreign data wrapper is, foreign tables behave just like normal PostgreSQL tables (at least when you read from them), so Npgsql won't even notice the difference.
Upvotes: 0
Related Questions
- How to access a HSTORE column using PostgreSQL C library (libpq)?
- How to set Postgres tables to use columnar storage using dbt?
- Are direct reads possible in postgresql
- Does Npgsql expose a strongly-typed list of PostgreSQL column types?
- Querying postgres from c# using npgsql
- User defined postgresql types using Npgsql from F#
- Change a normal table to a foreign "cstore_fdw" table
- How do I COPY to a cstore_fdw table in Citus?
- Using Npgsql to access postgresql from Power Query
- How can I use an hstore column type with Npgsql?