/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 vote388 views1 answer
Having all mysql
SQL
9 votes337 views4 answers
Last mysql
SQL
2 votes336 views1 answer
Oracle number to percentage
SQL
0 vote356 views1 answer
Ansi sql count duplicate rows
SQL
1 vote376 views1 answer
T-SQL / AZURE Reseed
SQL
3 votes366 views1 answer
Kill mysql processlist in whose time more than 200
SQL
0 vote346 views1 answer
Mysql update from n to 100
SQL
0 vote379 views1 answer
C# execute transact sql
SQL
25 votes369 views3 answers
How to use a database to see tables mysql
SQL
2 votes381 views1 answer
Postgresql create table as select
SQL

Share