Can I list only tables and/or views, no indexes?

user_287948 0
Viewed 55

Using psql on terminal and looking for all tables and views, but "\d mySchema. and tab" shows all objects, not only the important ones.

psql postgresql
1 Answers

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.

user_2879480
Related