/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 vote258 views2 answers
Insert sqlite
SQL
0 vote273 views1 answer
How to add mysql to path on termin after installation
SQL
5 votes303 views1 answer
Mysql count lines
SQL
0 vote270 views1 answer
Https://livesql.oracle.com/apex/livesql/s/l8fedwph53gt5gigbacwvu6m0
SQL
1 vote288 views1 answer
Liquibase alter column type / length
SQL
0 vote249 views1 answer
Adonisjs ER_NOT_SUPPORTED_AUTH_MODE: Client does not support authentication protocol requested by server; consider upgrading MySQL client
SQL
0 vote296 views1 answer
Min varias colunas spark sql
SQL
5 votes275 views2 answers
Mysqldump password
SQL
0 vote250 views1 answer
Mysql auto increment in YY-MM-XXX format
SQL
0 vote246 views1 answer
Create table if not exist with exceptions
SQL

Share