/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 vote161 views1 answer
Oracle boolean to varchar
SQL
0 vote197 views1 answer
Sql include rows with 0 values
SQL
0 vote219 views1 answer
How to print some string in mysql
SQL
22 votes224 views3 answers
Year format in date mysql
SQL
0 vote209 views2 answers
How to tun mysql on ubunto
SQL
2 votes193 views1 answer
Plsql left() function
SQL
0 vote199 views1 answer
Call function in query sql server
SQL
4 votes201 views1 answer
What are the data types in sql
SQL
1 vote218 views1 answer
Postgres set sequence value to max id
SQL
0 vote206 views1 answer
Grepper sql workbench download
SQL

Share