/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 votes383 views6 answers
Select sql
SQL
0 vote319 views1 answer
Oracle sqlp update amount / quantity
SQL
62 votes467 views8 answers
Mysql add column
SQL
0 vote376 views1 answer
Mysql average from two table
SQL
1 vote428 views1 answer
Sql and
SQL
1 vote351 views1 answer
Psql connections
SQL
0 vote349 views1 answer
Sqlalchemy query sql compiled
SQL
0 vote324 views1 answer
Add plugins to mysql workbench
SQL
0 vote339 views2 answers
Update query with between in mysql
SQL
0 vote334 views1 answer
Query to insert image
SQL

Share