Yan Pas <yanp.bugz@xxxxxxxxx> writes: > I'm writing C postgresql module with postgresql functions and want to > access the tables from inside (SELECT mostly and maybe INSERT). Is it > possible? If yes what API can I use except classic TCP connection (not sure > if it's even legal)? Recommended way is to use SPI: https://www.postgresql.org/docs/current/static/spi.html Aside from that documentation, there are lots of examples to study in the core code and contrib. regards, tom lane -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general