/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

1 vote158 views3 answers
Default password of mysql
SQL
0 vote184 views1 answer
Sp help text in postgresql
SQL
0 vote152 views1 answer
Get last three characters in mysql column
SQL
0 vote134 views1 answer
Import sql mysql ubuntu
SQL
10 votes162 views1 answer
Oracle dependencies table
SQL
0 vote148 views9 answers
Linq to sql converter online
SQL
2 votes150 views1 answer
Pandas to sql index
SQL
2 votes149 views2 answers
Postgres select duplicate columns
SQL
0 vote150 views1 answer
Update All tables COLLATE DATABASE_DEFAULT
SQL
2 votes150 views1 answer
How to make insert script from table in SQL server
SQL

Share