Wednesday, October 6, 2010

Postgresql cannot add new column

 Is Postgresql can add new column after/before specific existing column in table ???

Like :: 
ALTER TABLE some_tbl_name ADD some_column_name column_type AFTER some_existing_column_name
.
.
.
at

Centos 7 reset root/ any user lost password / lockout due to cant remember password

1. Need to be in front of the terminal. (Physically if not vm). 2. Reboot the server 3. Press 'e' in the GRUB2 boot screen. 3. bunch...