bigsmoke / pg_readme Goto Github PK

SELECT e.extname AS "Name", e.extversion AS "Version", n.nspname AS "Schema"
FROM pg_catalog.pg_extension e
	LEFT JOIN pg_catalog.pg_namespace n ON n.oid = e.extnamespace
	LEFT JOIN pg_catalog.pg_description c ON c.objoid = e.oid AND c.classoid = 'pg_catalog.pg_extension'::pg_catalog.regclass
ORDER BY 1;
+----------------+---------+------------+
|      Name      | Version |   Schema   |
+----------------+---------+------------+
| citus          | 11.2-1  | pg_catalog |
| citus_columnar | 11.2-1  | pg_catalog |
| hstore         | 1.8     | public     |
| pg_readme      | 0.5.5   | public     |
| plpgsql        | 1.0     | pg_catalog |
+----------------+---------+------------+
(5 rows)

SELECT pg_extension_readme('citus');
+------------------------------------------------------+
|                 pg_extension_readme                  |
+------------------------------------------------------+
| ---                                                 +|
| pg_extension_name: citus                            +|
| pg_extension_version: 11.2-1                        +|
| pg_readme_generated_at: 2023-01-25 16:29:23.03844+03+|
| pg_readme_version: 0.5.5                            +|
| ---                                                 +|
|                                                     +|
| Citus distributed database                           |
+------------------------------------------------------+
(1 row)

INFO: best version: pg_readme 0.3.5
INFO: saving /tmp/tmpz7xe6q5h/pg_readme-0.3.5.zip
INFO: unpacking: /tmp/tmpz7xe6q5h/pg_readme-0.3.5.zip
INFO: building extension
gmake: *** No rule to make target 'pg_readme-0.3.5.control', needed by 'all'.  Stop.
ERROR: command returned 2: gmake PG_CONFIG=/home/augustin/pgsql/bin/pg_config all