/SQL/Check table exist postgresql

Check table exist postgresql

Check table exist postgresql

"SELECT EXISTS (SELECT FROM pg_tables WHERE schemaname = 'public' AND tablename  = 'repair_service')"

0

Check table exist postgresql

SELECT EXISTS (
   SELECT FROM pg_tables
   WHERE  schemaname = 'schema_name'
   AND    tablename  = 'table_name'
   );

0

Source: stackoverflow.com

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';

-1

Similar codes

0 vote147 views1 answer
Soql queries for not contact related account records in salesforce
SQL
0 vote147 views1 answer
Get max salary from each department sql
SQL
0 vote172 views1 answer
INSERT INTO GBP Plus(Index Change) VALUES( AND((SELECT NUMINDEX FROM GBP WHERE ID>ID-1) - (SELECT NUMINDEX FROM GBP WHERE ID=ID ))
SQL
1 vote135 views1 answer
Find a column in all tables postgres
SQL
0 vote273 views1 answer
Why do we need data structure in sql
SQL
3 votes103 views1 answer
V$session not found in oracle
SQL
3 votes138 views1 answer
Oracle list dates without weekends
SQL
38 votes218 views6 answers
Ubuntu install mysql client
SQL
0 vote144 views1 answer
Bitmap join index
SQL
0 vote154 views1 answer
Python dictionary to sql update
SQL

Share