/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 vote310 views1 answer
Get statis values sql
SQL
1 vote259 views1 answer
Postgresql can you have null foreign key
SQL
0 vote194 views1 answer
Select all tables linked server sql
SQL
7 votes194 views3 answers
How to check table name in current database sql
SQL
0 vote207 views1 answer
Implicit inner join table alias with id values
SQL
5 votes214 views2 answers
Oracle rename table
SQL
5 votes287 views4 answers
Sqlite3.OperationalError: near "WHERE": syntax error
SQL
14 votes266 views1 answer
Excel is not a database
SQL
1 vote205 views2 answers
Mysql extract month
SQL
-1 vote267 views1 answer
Partial search in sql
SQL

Share