Postgresql
Python show all columns in PostgreSQL
List all columns of chosen table. Use advanced options to choose table schema. To show columns from tables from other databases change your connection. Credentials are loaded from .env file.
pythonpostgresqlsqlpsycopg.env
Required packages
You need below packages to use the code generated by recipe. All packages are automatically installed in MLJAR Studio.
psycopg>=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
- Check if there is an open connection.
- If not then open the connection.
- Try to query the database.
- Fetch results and show them to the user.
- If error occurs raise exception.
Example Python notebooks
Please find inspiration in example notebooks
Postgresql cookbook
Code recipes from Postgresql cookbook.
- « Previous
- Show all tables
- Next »
- Raw query to Pandas