Using psql
on terminal and looking for all tables and views, but "\d mySchema.
and tab" shows all objects, not only the important ones.
On psql v12.3
the \?
command say:
\dt[S+] [PATTERN] list tables
\dv[S+] [PATTERN] list views
So, using "\dt mySchema.
tab" you obtaim all TABLE names and with "\dt mySchema.
tab" you obtaim all VIEW names.
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