Public | history_session | table | scheduler If you’re using the psql command-line utility, then try the \dt built-in command. How do I show tables in PostgreSQL?Īnswers to this question may be found in a lot of places. However, even now, information schema support is not on the appropriate level in most databases. And probably it will never be, because the standard committee decided to use a different approach, called Information Schema. Secondly, it’s not part of the SQL standard. I would say never! Firstly, the SHOW command has its own semantics in PostgreSQL. When will SHOW TABLES be available in PostgreSQL? That allows anybody to use it as an extension to standard SQL. Now you know what the error message means: there is no run-time parameter with the name “tables”.īy the way, we have a comprehensive article on how to set PostgreSQL parameters.īut how can it be that the same command means opposite things in the two most popular open-source RDBMS? The answer is quite obvious: the SHOW command is not part of the SQL ISO or ANSI standard. People who come from MySQL are always asking the same question: why doesn’t the command SHOW TABLES work in PostgreSQL ?ĮRROR: unrecognized configuration parameter "tables"įirst of all, there is a SHOW command in PostgreSQL, but it’s responsible for returning the value of a run-time parameter. In this article, I will answer the questions: why isn’t there a SHOW TABLES command in PostgreSQL, when will SHOW TABLES in PostgreSQL be available, and how do I list tables with native PostgreSQL methods? Why isn’t there a SHOW TABLES command in PostgreSQL?
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |