Pre-requisites

Debian

apt-get install build-essential libreadline-dev zlib1g-dev flex bison

RHEL

yum install gcc glibc glib-common readline readline-devel zlib zlib-devel flex bison

Install pg-gsheets

Clone or download the source code zip. Run the following command in the source code directory to build and install the extension.

make install

Check if the pg_config utility is in your PATH by running pg_config. If it’s not found, provide the path:

make PG_CONFIG=/path/to/postgres/bin/pg_config install