/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

7 votes352 views2 answers
MySQL IF without else
SQL
1 vote297 views1 answer
Foreign key constraint in ms sql
SQL
11 votes351 views6 answers
Mysql else if
SQL
8 votes333 views3 answers
Postgresql connection string c#
SQL
0 vote314 views1 answer
Mysql select all where count more than"
SQL
0 vote323 views1 answer
How to get first 10 records of a table in mysql
SQL
4 votes360 views1 answer
An error occurred while installing pg (1.2.3), and Bundler cannot continue. Make sure that `gem install pg -v '1.2.3' --source 'https://rubygems.org/'` succeeds before bundling.
SQL
0 vote321 views1 answer
Sql clear table
SQL
3 votes331 views1 answer
Null sql
SQL
0 vote301 views1 answer
Is not null postgresql
SQL

Share