Search
 
SCRIPT & CODE EXAMPLE
 
CODE EXAMPLE FOR SQL

how to check table exists or not in postgresql

SELECT 1 FROM information_schema.tables
WHERE table_schema = 'schema_name'	AND table_name = 'table_name';
 
PREVIOUS NEXT
Tagged: #check #table #exists #postgresql
ADD COMMENT
Topic
Name
4+2 =