PostgreSQL check if table exist throwing "relation does not exist" error

Question

In PostgreSQL I try to check if table exist:

SELECT EXISTS (SELECT * FROM table_name);

And it throwing an error. How can I check if table already exists so the result will be boolean? Because currently I can achieve the same with try-catch (enters to catch if not exist) instead of if-else on the result...

Thanks,

stackoverflow.com/questions/20582500/…

caiohamamura
– caiohamamura

2016-07-18 16:56:10 +00:00
Commented Jul 18, 2016 at 16:56 — caiohamamura
– caiohamamura, Commented Jul 18, 2016 at 16:56

user6505611 · Accepted Answer · 2016-07-18 16:56:58Z

4

Either of these should work, though depending on how your permissions are set up you may not have access to the tables:

SELECT EXISTS (SELECT relname FROM pg_class WHERE relname = 'table_name');

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

answered Jul 18, 2016 at 16:56

user6505611

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

Collectives™ on Stack Overflow

PostgreSQL check if table exist throwing "relation does not exist" error

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related