Postgresql

Python show all tables from PostgreSQL

List all tables using the current connection and .env credentials. Use advanced options to show schemas. Change the connection to view other databases.

pythonpostgresqlsqlpsycopg.env

Required packages

You need below packages to use the code generated by recipe. All packages are automatically installed in MLJAR Studio.

psycopg[binary]>=3.2.1

Interactive recipe

You can use below interactive recipe to generate code. This recipe is available in MLJAR Studio.

In the below recipe, we assume that you have following variables available in your notebook:

  • conn (type Connection)

Python code

# Python code will be here

Code explanation

  1. Check if there is an open connection.
  2. If not then open the connection.
  3. Try to query the database.
  4. Fetch results and show them to the user.
  5. If error occurs raise exception.
« Previous
Connect to database
Next »
Show all columns