List tables only in one schema with \dt meta-command

[harryrundles]

Hi all,

Has anyone figured out how to list the tables from just one schema using the \dt meta-command? If I just type \dt I get a list of all tables but I just want to see those in the public schema.

I tried this:

Code: Select all

dbadmin=> \dt public
No matching relations found.

... and this:

Code: Select all

dbadmin=> Please show me just the tables in the public schema;
ERROR 4856:  Syntax error at or near "Please" at character 1
LINE 1: Please show me just the tables in the public schema;

Neither method worked obviously!

Thanks,
Harry

[JimKnicely]

Try:

Code: Select all

\dt public.*

The "Please show me just the tables in the public schema;" feature may be added in Vertica 7...

[harryrundles]

Thanks, Jim! Wow, why didn't I think of the wildcard?