Initialize Fetchq

So far you have a plain Postgres running, as it comes out from the factory. Fetchq extension files are shipped within the container, but the extension itself needs to be created:

CREATE EXTENSION IF NOT EXISTS "fetchq";

You may also want to create the extension uuid-ossp which is a core extension used to generate unique document names, useful for appending unique documents into a queue.

CREATE EXTENSION IF NOT EXISTS "uuid-ossp";

At this point you are ready to initialize Fetcqh and create the basics schema for your database:

SELECT * FROM fetchq_init();

Test your installation by listing the tables in the public schema:

SELECT * FROM pg_catalog.pg_tables WHERE schemaname = 'public';

pg-tables

results matching ""

    No results matching ""