useful sql for pgSTAC

# Output list of tables from pgstac schema
select table_name
from information_schema.tables
where table_schema = 'pgstac'
order by table_name;

# \d = describe object(s)
# t = table, f = function
# + = details
\dt pgstac.*

# describe functions in detail
\df+ pgstac.*

# Describe collections
\d pgstac.collections