/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 vote133 views1 answer
Drop a field in psql django
SQL
0 vote131 views1 answer
Mysql set variable to today's date
SQL
2 votes230 views1 answer
Sql ends with string
SQL
0 vote129 views4 answers
First max salary in sql
SQL
1 vote140 views1 answer
Mysql return if it contains
SQL
15 votes138 views6 answers
Psql
SQL
0 vote134 views1 answer
Oracle sql copy table without data
SQL
0 vote138 views1 answer
Mysqli_real_connect(): (28000/1045): Access denied for user 'u0738423'@'www8.aname.net' (using password: YES)
SQL
2 votes148 views1 answer
Sql percentage with % rounded down
SQL
0 vote141 views1 answer
Learnxinyminutes sql
SQL

Share