/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 votes209 views2 answers
Postgresql select all column names
SQL
-1 vote204 views1 answer
Select first rows postgresql
SQL
2 votes209 views1 answer
Use cases condition in sql query laravel
SQL
0 vote199 views1 answer
Ajax error exception handeling
SQL
0 vote266 views1 answer
Postgresql print variable
SQL
2 votes229 views2 answers
Sql query to list all tables in a database sql server
SQL
0 vote262 views1 answer
TSQL Find csv file in folder
SQL
1 vote209 views1 answer
Mysql get max value and id
SQL
4 votes214 views2 answers
REST API
SQL
0 vote190 views1 answer
C# check if mysql query modified rows
SQL

Share