/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 vote366 views1 answer
Opensuse restart MySQL
SQL
5 votes308 views1 answer
Ignore duplicate rows in sqlite
SQL
0 vote340 views1 answer
Load data infile mariadb slow
SQL
0 vote304 views1 answer
Can we rollback deleted data in sql
SQL
2 votes299 views4 answers
ModuleNotFoundError: No module named 'mysql'
SQL
4 votes316 views3 answers
Copy table postgres
SQL
11 votes342 views1 answer
Ddl view
SQL
14 votes331 views2 answers
Oracle add column with default value
SQL
0 vote288 views1 answer
Store query result in variable sql
SQL
0 vote314 views1 answer
Python mysql query to dataframe
SQL

Share