Hello. I type \dt as user postgres, but it show only the tables within
public schema. I need to know all tables (like v$_ or dba_ or user_
in oracle). How I do that?
Thanks.
Robby Russell wrote:
> Peter Moscatt wrote:
> >Is there a SQL command I can issue which will list all the TABLES within
> >a database ?
>
> Well, when you are the postgres commandline client, you can type
> # \dt
>
> That will show all the tables in your current database.