Comment 3 for bug 1802078

$ snap info postgresql
error: no snap found for "postgresql"

$ snap find postgresql
Name Version Publisher Notes Summary
datagrip 2019.2.5 jetbrains✓ classic IntelliJ-based IDE for databases and SQL
squirrelsql 4.0.0 jibel - A Java SQL client for any JDBC compliant database
dbeaver-ce 5.2.5 rasul-dbeaver - Universal Database Tool
postgresql93 9.3.23 cmd✓ - PostgreSQL is a powerful, open source object-relational database system.
postgresql94 9.4.18 cmd✓ - PostgreSQL is a powerful, open source object-relational database system.
postgresql95 9.5.13 cmd✓ - PostgreSQL is a powerful, open source object-relational database system.
postgresql96 9.6.9 cmd✓ - PostgreSQL is a powerful, open source object-relational database system.
postgresql10 10.4 cmd✓ - PostgreSQL is a powerful, open source object-relational database system.
postgresql-pgbouncer 1.7.2 cmd✓ - Lightweight connection pooler for PostgreSQL
postgresql95-pgpool2-35 3.5.4 cmd✓ - pgpool-II is a connection pooler for PostgreSQL.
postgresql95-pgpool2-36 3.6.0 cmd✓ - pgpool-II is a connection pooler for PostgreSQL.
postbird 0.8.2 pavel-evst - PostgreSQL GUI client
wal-e 1.1.0 stub classic Continuous archiving of PostgreSQL WAL files and base backups
yorokobi 0.1.0 martincaetano - Automatic PostgreSQL backups for web apps.
quasselcore-moon127 0.12.5 moon127 - Quassel Core
bjornt-prometheus-postgres-exporter 0.0.1 bjornt - Prometheus Postgresql Exporter
query-exporter 1.8.1+git6.4bcdc2f ack - Export Prometheus metrics from SQL queries
test-postgres-system-usernames 10 anonymouse67 - PostgreSQL

Looks like postgres now has a snap per major version.

A typical snap with non-latest tracks is node:

$ snap info node
name: node
summary: Node.js
publisher: NodeSource, Inc. (nodesource✓)
contact: https://github.com/nodesource/distributions
license: MIT
description: |
  A JavaScript runtime built on Chrome's V8 JavaScript engine. Node.js uses an event-driven,
  non-blocking I/O model that makes it lightweight and efficient. Node.js' package ecosystem, npm,
  is the largest ecosystem of open source libraries in the world. https://nodejs.org/
snap-id: MEd4V4HHFkCXBSz6UzVmKF2D2PmWcVwR
channels:
  stable: –
  candidate: –
  beta: –
  edge: 13.0.0-nightly20190802452b393c 2019-08-02 (2494) 20MB classic
  12/stable: 12.13.0 2019-10-21 (2525) 20MB classic
  12/candidate: ↑
  12/beta: ↑
  12/edge: ↑
  11/stable: 11.15.0 2019-06-26 (2336) 19MB classic
  11/candidate: ↑
  11/beta: ↑
  11/edge: ↑
  10/stable: 10.16.1 2019-07-31 (2485) 19MB classic
  10/candidate: ↑
  10/beta: ↑
  10/edge: ↑
  9/stable: 9.11.2 2018-12-14 (1407) 17MB classic
  9/candidate: ↑
  9/beta: ↑
  9/edge: ↑
  8/stable: 8.16.0 2019-06-24 (2310) 16MB classic
  8/candidate: ↑
  8/beta: ↑
  8/edge: ↑
  6/stable: 6.17.1 2019-06-24 (2311) 13MB classic
  6/candidate: ↑
  6/beta: ↑
  6/edge: ↑

it does appear on the search:

$ snap find node |head
Name Version Publisher Notes Summary
node 13.0.0-nightly20190802452b393c nodesource* classic Node.js
webstorm 2019.2.3 jetbrains* classic Powerful IDE for modern JavaScript development

(this may be because node has something on latest/edge though)