schema (2) 썸네일형 리스트형 [psycopg2] Exploring Postgres Database Internals 1. Exploring Internal tables 1.1 Check whole table in database Inside Postgres engine, there is a set of internal tables used to manage the overall structue of the database. These tables are located inside the information_schema or system catalogs table set. The table includes information on data, the name of the table, and the type stored in the database. For example, cursor.description is an a.. [psycopg2] Database Management 1. Database Management 1.1 Create Database Postgres can create multiple databases inside the server. The databse can be created with CREATE DATABASE clause, and the OWNER option is used to specify who owns the databse. If the OWNER option is not specified, the current user user is the owner. import psycopg2 conn = psycopg2.connect(dbname="db", user="ur") conn.autocommit = True cursor = conn.curs.. 이전 1 다음