/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

4 votes231 views2 answers
How to insert ip address in mysql using php
SQL
0 vote240 views1 answer
Python sqlalchemy connection show server
SQL
-1 vote287 views4 answers
Full outer join in sql
SQL
0 vote232 views1 answer
Narural join
SQL
0 vote257 views1 answer
Primary key multiple
SQL
0 vote245 views3 answers
CONTACT FORM SQL
SQL
1 vote263 views2 answers
Drop table with constraints
SQL
0 vote230 views1 answer
Mysql docker image for macbook m1
SQL
0 vote234 views1 answer
Add unique constraint sql server multiple columns
SQL
1 vote240 views1 answer
Postgresql transaction discard all
SQL

Share