/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 vote241 views1 answer
Select value from previous row in postgresql
SQL
11 votes325 views2 answers
Import mysql dump command line windows
SQL
0 vote267 views1 answer
Postgres : ERROR: division by zero
SQL
0 vote275 views1 answer
Alter table change default
SQL
0 vote284 views2 answers
Dumping sql table
SQL
0 vote258 views1 answer
FIND AVERAGE SALARY EARNER IN SQL
SQL
0 vote272 views1 answer
Sql server create constraint
SQL
10 votes266 views4 answers
Sql pagination
SQL
13 votes258 views5 answers
Select last row mysql
SQL
2 votes266 views1 answer
How to create sql database
SQL

Share