Answers for "postgres test if table exists shell"

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';

Posted by: Guest on June-24-2020

postgres check if item exists in database

# Django: if yourName and yourNumber exist in YourModel then delete all rows
YourModel.objects.filter(name='yourName', numb='yourNumber').delete()

Posted by: Guest on September-06-2021

Code answers related to "postgres test if table exists shell"