Search
 
SCRIPT & CODE EXAMPLE
 

SQL

postgres get all tables in schema

SELECT * FROM information_schema.tables 
WHERE table_schema = 'public'
Comment

get all tables postgres

SELECT * FROM pg_catalog.pg_tables;
Comment

list all tables in postgres schema

dt schema_name.*
Comment

psql list tables in schema

=> dt *.*
Comment

psql list tables in schema

=> dt public.*
Comment

PREVIOUS NEXT
Code Example
Sql :: django.core.exceptions.ImproperlyConfigured: mysqlclient 1.4.0 or newer is required; you have 0.10.1. 
Sql :: forgot mysql root password stackoverflow 
Sql :: find duplicates mysql column 
Sql :: mysql_secure_installation 
Sql :: mysql change user password 
Sql :: finding last created table mysql 
Sql :: oracle get current schema 
Sql :: refresh postgres config 
Sql :: commentaire table oracle 
Sql :: wilayah indonesia database 
Sql :: sql server get users 
Sql :: sql add year to date 
Sql :: mysql command line xampp ubuntu 
Sql :: sql server check version 
Sql :: psql connections 
Sql :: OSError: mysql_config not found 
Sql :: sql last row in table 
Sql :: sql drop schema 
Sql :: drush sql-dump 
Sql :: oracle start job 
Sql :: mysql import ignore errors 
Sql :: PLS-00225 type 
Sql :: postgres delete database 
Sql :: sqlite insert row 
Sql :: Sql query to force the database to be drop 
Sql :: String concatenation in PostgreSQL 
Sql :: postgresql create table with index 
Sql :: funzioni plsql 
Sql :: tsql find foreign key references 
Sql :: how to start mysql in terminal 
ADD CONTENT
Topic
Content
Source link
Name
4+2 =