Is there any way to list all tables that contain certain keywords in psql?
In other words, is there a similar command as in mysql:
show tables like "%test%"
?
Just found the answer..
\dt *test*
will pull tables: 123_test_234, test_234, 123_test etc.
\dt *test
will pull tables: 123_test etc.
\dt test*
will pull tables: test_234 etc.
Not sure if there is a similar question. If there is, maybe I should delete this.
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With