PostgreSQL query to list all table names

Question

Is there any query available to list all tables in my Postgres DB   I tried out one query like   SELECT table name FROM information schema tables                       WHERE table schema  public     But this query returns views also   How can i get only table names only  not views

User · Answer

Try this     SELECT table name  FROM information schema tables  WHERE table schema  public  AND table type  BASE TABLE    this one works

User · Answer

What bout this query  based on the description from manual    SELECT table name   FROM information schema tables  WHERE table schema  public     AND table type  BASE TABLE

User · Answer

If you want list of database  SELECT datname FROM pg database WHERE datistemplate   false    If you want list of tables from current pg installation of all databases  SELECT table schema table name FROM information schema tables ORDER BY table schema table name

User · Answer

SELECT table name FROM information schema tables WHERE table type  BASE TABLE  AND table schema  public     For MySQL you would need table schema  dbName  and for MSSQL remove that condition   Notice that  only those tables and views are shown that the current user has access to   Also  if you have access to many databases and want to limit the result to a certain database  you can achieve that by adding condition AND table catalog  yourDatabase   in PostgreSQL    If you d also like to get rid of the header showing row names and footer showing row count  you could either start the psql with command line option -t  short for --tuples-only  or you can toggle the setting in psql s command line by  t  short for  pset tuples only   This could be useful for example when piping output to another command with  g    command

User · Answer

select   relname as table  from   pg stat user tables  where schemaname    public     This will not work if track activities is disabled     select    tablename as table  from    pg tables   where schemaname    public     Read more about pg tables

User · Answer

How about giving just  dt in psql  See https   www postgresql org docs current static app-psql html

User · Answer

Open up the postgres terminal with the databse you would like   psql dbname  run this line in a terminal    then  run this command in the postgres environment   d   This will describe all tables by name  Basically a list of tables by name ascending   Then you can try this to describe a table by fields    d tablename    Hope this helps

[postgresql] PostgreSQL query to list all table names?

Examples related to postgresql

Examples related to postgresql-9.2

Examples related to information-schema