index.md

PSQL queries

General:

• Normalize

Key searches:

• Count number of occurrences of keywords/keysentences (pages) and group by year

Note: For running any of above queries, they need NLS pages to be stored previously in PSQL using this query

Important: We recommend to read also the documentation for writing and reading data from/to PSQL.