Answers for "SELECT table_name FROM information_schema.tables WHERE table_schema = 'public' ORDER BY table_name;"

postgresql get table names

SELECT table_name
  FROM information_schema.tables
 WHERE table_schema='public'
   AND table_type='BASE TABLE';

Posted by: Guest on May-26-2020

Code answers related to "SELECT table_name FROM information_schema.tables WHERE table_schema = 'public' ORDER BY table_name;"