Search
 
SCRIPT & CODE EXAMPLE
 

SQL

postgresql get table names

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

postgresql how to show table names

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

PREVIOUS NEXT
Code Example
Sql :: cambiar nombre tabla mysql 
Sql :: mysql 3 months ago 
Sql :: show tables sql server 
Sql :: rails execute sql 
Sql :: see all databases mysql 
Sql :: postgresql add enum value 
Sql :: this month mysql where 
Sql :: sql server beginning of month 
Sql :: oracle string length 
Sql :: mysql search for column name in all tables 
Sql :: query to find table size in oracle 12c 
Sql :: mysql update field from one table to another 
Sql :: alter schema sql 
Sql :: oracle rename table 
Sql :: drop view in mysql 
Sql :: psql filed name alter 
Sql :: psql get sequences 
Sql :: postgres stop server mac 
Sql :: linux command line import mysql database 
Sql :: postgres alter table add primary key 
Sql :: how to update date add hours in postgresql 
Sql :: sql server cast date dd/mm/yyyy 
Sql :: import database in phpmyadmin command line 
Sql :: xampp mysql database not starting 
Sql :: influxdb export to csv 
Sql :: sql getdate minus 1 day without time 
Sql :: postgres remove foreign key constraint 
Sql :: mysql id of inserted row 
Sql :: change mysql root password 
Sql :: Aqua Data studio postgresql ssl 
ADD CONTENT
Topic
Content
Source link
Name
7+6 =