Answers for "set default postgresql date field value to date now"

SQL
0

postgresql create table default value timestamp

CREATE TABLE `table_name`(
	`id` SERIAL PRIMARY KEY,
	`created_at` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
	`modified_at` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
)
Posted by: Guest on September-23-2021
1

postgres default value

ALTER TABLE your_tble ADD COLUMN your_col VARCHAR(8) DEFAULT 'sometext';
Posted by: Guest on August-27-2021

Code answers related to "SQL"

Browse Popular Code Answers by Language