/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
Invalid reference to FROM-clause entry for table "unidades
SQL
1 vote181 views1 answer
Input in mysql
SQL
0 vote242 views2 answers
Uninstall postgresql mac
SQL
0 vote196 views2 answers
Import .sql into postgres db command
SQL
0 vote207 views1 answer
Sqlcmd no headers
SQL
0 vote205 views1 answer
Split first name and last name in sql
SQL
0 vote173 views1 answer
Create table with primary key and foreign key in sql server
SQL
25 votes216 views3 answers
Mysql command show tables
SQL
0 vote271 views1 answer
Get last inserted primary key
SQL
3 votes124 views1 answer
How to get list of synonyms in oracle
SQL

Share