/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

4 votes170 views1 answer
Mysql timestamp in laravel migration
SQL
0 vote203 views1 answer
Port 5432 is already in use Usually this means that there is already a PostgreSQL server running on your Mac. If you want to run multiple servers simultaneously, use different ports.
SQL
1 vote170 views1 answer
Join first name and last name sql
SQL
0 vote171 views2 answers
T sql null or empty string
SQL
0 vote165 views1 answer
Mysql case when null
SQL
0 vote168 views1 answer
Group_concat only returns one row
SQL
1 vote191 views5 answers
Sql 2nd highest salary
SQL
1 vote183 views1 answer
Oracle sql first day of year
SQL
0 vote199 views1 answer
Ubuntu connect to mssql database
SQL
0 vote168 views1 answer
Postgresql interview questions
SQL

Share