cheack wheter a table exists or not

[ahchew1413]

Hello:

to check wheter a file exists or not, we are using function file_exists. Then, when i want to check wheter a table(in relational database: postgres) exists or not, what function should i use, or is that any way to do it??

thanks for reading

ahchew1413

[Lars_Berg]

Why do you need to check whether a table exists? Define the datamodel and implement it. If you need to change the model, do it offline and test it out properly before doing an upgrade.

You don't add flexibility to a data model by adding and removing tables at runtime.

[barand]

Intermediate temporary tables?

[chriskl]

Just do this:

SELECT * FROM pg_tables WHERE tablename='{table}';

If anything is returned, then the table exists.

Chris