lundi 24 septembre 2018

PostgreSQL table row goes to the bottom when updating

I am currently migrating from MySQL to PostgreSQL in a Laravel application, and I noticed that when updatin, the row goes to the end of the table (bottom). In Mysql, it remains in the same position it occupied before the update. Is there any way to apply this function? Would it be a InnoDB feature? Using Navicat Premium 12.1 DBMS. I think this is just an aesthetic factor, but even so I would like to learn how to carry out this "permanent ordination". The database is in UTF-8 encoding and pt_BR.UTF8 collation and ctype. Following is the table:

CREATE TABLE properties ( id int(11) NOT NULL AUTO_INCREMENT PRIMARY KEY, title varchar(255) NOT NULL, description text NOT NULL, name varchar(255), rental_price decimal(10, 2), sale_price decimal(10, 2) );

Thank you all!



via Chebli Mohamed

Aucun commentaire:

Enregistrer un commentaire