This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revision Previous revision
postgres_data_modelling [2018/12/19 07:53]
root [Enums]
postgres_data_modelling [2018/12/19 07:56] (current)
root [Table Management]
Line 76: Line 76:
 +To rename a table 
 <code sql> <code sql>
 ALTER TABLE public.jobstatus RENAME TO job_status; ALTER TABLE public.jobstatus RENAME TO job_status;
 +To drop/delete a column
 +<code sql>
 +alter table job_status
 +drop column id
 </​code>​ </​code>​
postgres_data_modelling.txt · Last modified: 2018/12/19 07:56 by root
RSS - 200 © CrosswireDigitialMedia Ltd