PROGRAMMING
Databases
Article by:
Geoffrey Hunter
Date Published: | |
Last Modified: |
MariaDB
To change the position of a column:
|
|
More info at https://mariadb.com/kb/en/alter-table/.
PostgreSQL
PostgreSQL is a object-orientated database. The main feature of a object-orientated database is that tables can inherit from other tables, which means they automatically get all the data columns of the table they inherit from (similar to object inheritance in object-orientated programming languages).
Inheritance is defined when creating tables with the INHERITS
clause with the CREATE TABLE
statement:
|
|
If a table already exists, you can inheritance via the INHERIT
variant of the ALTER TABLE
statement.
Working With PostgreSQL In Python
One of the most popular PostgreSQL libraries for Python is psycopg2
. To install it on Ubuntu you will also need the libpg-dev
package on your system:
|
|
Authors

This work is licensed under a Creative Commons Attribution 4.0 International License .
Related Content:
- ReStructuredText
- Consistent Overhead Byte Stuffing (COBS)
- How To Change The IO Scheduling Class And Priority In Linux
- Mbed Studio
- STM32CubeIDE