/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 vote205 views1 answer
Mysql default tls v1.3 ciphersuites
SQL
-2 votes198 views3 answers
Sqlite reset autoincrement
SQL
0 vote192 views1 answer
How to check the port of mysql installation in mac
SQL
2 votes209 views1 answer
Install postgresql centos 5
SQL
17 votes221 views1 answer
Selecting name that contain certain word in sql
SQL
15 votes291 views4 answers
Mysql export database command line
SQL
0 vote216 views1 answer
Insufficient privileges while creating view in sql oracle
SQL
0 vote193 views1 answer
Convert .mdf to .bak
SQL
1 vote192 views3 answers
How to get date in sql
SQL
1 vote192 views2 answers
Sql convert datetime to year month
SQL

Share