Skip to main content

New answers tagged

0 votes

List PostgreSQL extensions per database

I'm not sure if this can be automated directly in psql, as AFAIK you can't do cross-database queries. But you can easily automate this with some Bash. Here is quick script, which will list all ...
Kepi's user avatar
  • 101
-3 votes

How do I select arrays that are not empty?

We can use below query: SELECT lexemes FROM ts_debug WHERE alias !='{}';
Aditya's user avatar
  • 1

Top 50 recent answers are included