/SQL/Postgresql get table names

Postgresql get table names

Postgresql get table names

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

1

Source: stackoverflow.com

Postgresql how to show table names

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

1

Source: stackoverflow.com

Similar codes

0 vote241 views1 answer
MySql shutdown unexpectedly InnoDB: Mutexes and rw_locks use Windows interlocked functions InnoDB: Uses event mutexes
SQL
0 vote227 views1 answer
Mariadb LOAD DATA INFILE
SQL
2 votes245 views1 answer
Query to check cpu utilization in oracle database
SQL
2 votes252 views1 answer
Oracle sql merge
SQL
0 vote231 views1 answer
Sql server obtener nombre sin espacios en blanco
SQL
0 vote248 views2 answers
Call to undefined function mysqli_fetch_all()
SQL
5 votes248 views4 answers
Restart the psql server windows
SQL
0 vote284 views1 answer
How to use mysql_tzinfo_to_sql on windows
SQL
4 votes255 views2 answers
Could not find driver (SQL: SHOW FULL TABLES WHERE table_type = 'BASE TABLE')
SQL
13 votes262 views5 answers
Alter table query sql server change column
SQL

Share