'Postgres 9.4 - Check if a table exist in database

I would like to know if Postgresql has implemented a function that runs automatically and returns me if a table is created in the database independently of the schema.

version : Postgresql 9.4

Thanks!

postgresqldatabase-administrationpostgresql-9.4


Solution 1:[1]

You could query information_schema.tables, but that will only give you information about tables on which you have privileges:

SELECT EXISTS (SELECT 1
               FROM information_schema.tables
               WHERE table_name = 'guppy');

Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source
Solution 1 Laurenz Albe

Related Questions