10/28/2023 0 Comments Postgres show all databases![]() ![]() This query retrieves the names of all base tables from the information_schema.tables view, excluding system tables. Connect to your PostgreSQL database using the appropriate credentials.ĪND table_schema NOT IN ('pg_catalog', 'information_schema').Open your favorite PostgreSQL client, such as pgAdmin or any other database management tool.Type the following to display a list of all tables in the current database:.Replace database_name with one of the available databases. Then type this command to switch to the database. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |