/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

3 votes191 views2 answers
Sql random integer
SQL
1 vote210 views2 answers
One to one and one to many relationship
SQL
1 vote173 views1 answer
Set id count mysql
SQL
2 votes342 views1 answer
Set auto increment from 1
SQL
1 vote185 views1 answer
Drop df constraint sql server
SQL
-1 vote242 views1 answer
Add 10 to all numbers in a column sql
SQL
19 votes188 views5 answers
Change column name mysql command line
SQL
2 votes181 views1 answer
Change primary key sql
SQL
12 votes203 views1 answer
Run mysql instance in docker
SQL
19 votes191 views6 answers
Sql drop table if exists
SQL

Share