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

show all tables postgres

dt
# show list of tables in postgres
Comment

list all tables in postgres

c database_name

dt
Comment

PREVIOUS NEXT
Code Example
Sql :: copy table sql server 
Sql :: sql server beginning of month 
Sql :: how to add boolean column in postgresql 
Sql :: install mysql ubuntu 18.04 
Sql :: how to check port number for postgresql 
Sql :: mysql search for column name in all tables 
Sql :: postgres alter user password 
Sql :: show list of users in mysql 
Sql :: date today snowflake 
Sql :: oracle apex version view 
Sql :: postgres change the name of schema 
Sql :: how to see which columns are indexxed mysql 
Sql :: oracle search stored procedures for text 
Sql :: import sql mysql ubuntu 
Sql :: postgres install unaccent extension 
Sql :: postgres stop server mac 
Sql :: how to get list of synonyms in oracle 
Sql :: mysql history command 
Sql :: postgres change column type string to integer 
Sql :: Check Table Exists 
Sql :: sqlserver add column to table 
Sql :: cannot pip install mysqlclient 
Sql :: install mysql powershell 
Sql :: t-sql disable system versioning 
Sql :: sqlite print all column names 
Sql :: sql server if exists update else insert 
Sql :: mysql show table column full description 
Sql :: encoding UTF8 has no equivalent in encoding WIN1252 
Sql :: sql query with replace function 
Sql :: postgresql make each element in array distinct 
ADD CONTENT
Topic
Content
Source link
Name
1+7 =