/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 vote177 views1 answer
Postrgres trunc
SQL
0 vote159 views1 answer
Access denied for user 'root'@'localhost' workbench ubuntu
SQL
1 vote170 views1 answer
Sqlite3 read only
SQL
3 votes165 views2 answers
Create schema postgres
SQL
0 vote215 views1 answer
Eliminate zero from integer mysql
SQL
1 vote182 views2 answers
Sqlstate[hy000]: general error: 1005 can't create table (errno: 150 "foreign key constraint is incorrectly formed")
SQL
0 vote180 views1 answer
Select sql in descending order
SQL
22 votes167 views4 answers
Show list of users in mysql
SQL
16 votes165 views3 answers
Delete row psql
SQL
0 vote179 views1 answer
Sqlalchemy one column of two has to be not null
SQL

Share