As a memo, I will write how to import csv and export csv in PostgreSQL.
First , login PostgreSQL Database and execute command below.
Export to CSV\copy TABLE_NAME to path_to_filename.csv delimiter ',' csv header;
Import from CSV\copy TAB
As a note, I will summarize below the method for creating your own custom commands in Django.
Create app_name/management/commands Directorycreate management directory and create __init__py file and commands directory in it.
Create Custom
Here is the standard pattern for retrieving list-type data via an API using Python.
def getAllContents(page_num=1): contents = [] page_num = 1 endpoint = "https://example.com/content?page_num=" + str(page_num) headers = {'Autho
Here is a summary of commonly used PostgreSQL commands:
Connect to databasebash command
$ psql -h HOST_NAME -p PORT_NUMBER -U USER_NAME -d DATABASE_NAME
From here on, I will list SQL commands.
Show list of databases\l
Create DatabaseCR
As a memo, I will compile the steps for installing PostgreSQL on Ubuntu Desktop for development.
Install PostgreSQLInstall according to the instructions on the official website.
# Create the file repository configuration:$ sudo sh -c 'ech
Ubuntu 22.04 Settings to use AirPods and Logicool Mouse
Airpods setting in Ubuntu22.04Rewrite /etc/bluetooth/main.conf
$ sudo vi /etc/bluetooth/main.conf
Change ControllerMode value.
ControllerMode = bredr
Restart Bluetooth service
$ sudo systemctl restart bluetooth
Logicool setting in Ubu
Ubuntu 22.04 Settings to use AirPods and Logicool Mouse
