Add a META.json

[theory]

And release on PGXN?

{
   "name": "uri",
   "abstract": "A URI type for PostgreSQL",
   "description": "This is an extension for PostgreSQL that provides a uri data type. The actual URI parsing is provided by the uriparser library, which supports URI syntax as per RFC 3986.",
   "version": "1.20150415.0",
   "maintainer": "Peter Eisentraut <[email protected]>",
   "license": "postgresql",
   "provides": {
      "uri": {
         "abstract": "A URI type for PostgreSQL",
         "file": "uri.sql",
         "docfile": "README.md",
         "version": "1.20150415.0"
      }
   },
   "prereqs": {
      "runtime": {
         "requires": {
            "PostgreSQL": "9.1.0"
         }
      }
   },
   "resources": {
      "bugtracker": {
         "web": "https://github.com/petere/pguri/issues/"
      },
      "repository": {
        "url":  "git:https://github.com/petere/pguri.git",
        "web":  "https://github.com/petere/pguri/",
        "type": "git"
      }
   },
   "generated_by": "David E. Wheeler",
   "meta-spec": {
      "version": "1.0.0",
      "url": "https://pgxn.org/meta/spec.txt"
   },
   "tags": [
      "uri",
      "url",
      "data type"
   ]
}

[nyov]

👍 to a pgxn release. That might also help with seeing it packaged in distributions... eventually.