Cookbook
Postgresql
Tool which allows you to define new Postgrasql database connection with credentials stored in .env file. Exqcute sql queries such as SELECT, CREATE TABLE, DROP TABLE, UPDATE TABLE.
Define a new connection
Define new database connection using simple Python code. Provide database credentails ...Connect to database
Open new Postgresql database connection using simple Python code. Credentials are ...Show all tables
List all tables of previously configured Postgresql database connection. Choose ...Show all columns
List all columns of previously configured Postgresql database connection. Provide ...Raw query to Pandas
Run a sql query usign previously configured Postgresql connection and crate pandas ...Raw query
Simply run a sql query usign previously configured Postgresql connection. You can ...Run select query
Execute sql select query on previously configured Postgresql connection. Credentials ...Run insert query
Execute sql insert query on previously configured Postgresql connection. Credentials ...Create table
Create new database table usign previously configured Postgresql connection. Credentials ...Drop table
Drop table from database usign previously configured Postgresql connection. Credentials ...
- « Previous
- Save to Pickle
- Next »
- Define a new connection