Postgres 9.4 - Check if a table exist in database

Question

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!

There is no built-in function. You will have to use a SELECT statement checking pg_class or pg_tables — user330315
– user330315, Commented May 11, 2022 at 11:34

Laurenz Albe · Accepted Answer · 2022-05-11 12:04:29Z

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

answered May 11, 2022 at 12:04

Laurenz Albe

257k22 gold badges313 silver badges389 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Postgres 9.4 - Check if a table exist in database

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related