/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 vote324 views0 answer
SQL
0 vote375 views1 answer
Mysql search like but first exact match
SQL
1 vote429 views1 answer
Sql select sum group by id laravel
SQL
0 vote355 views1 answer
Prepared statement mysql java delete selected rows
SQL
4 votes361 views1 answer
Group by mysql and concatenate string
SQL
0 vote391 views1 answer
Oracle sql how to overcome 999 limit for IN
SQL
0 vote364 views1 answer
Get current date data in mysql
SQL
0 vote379 views1 answer
Flask sqlalchemy. commit does not save changes
SQL
1 vote353 views1 answer
Mysql select update same table
SQL
-1 vote382 views1 answer
SQL SERVER microsoft How to Add Column at Specific Location in Table
SQL

Share