How to create table with timestamp in postgres?



How to create table with timestamp in postgres?..

Answer / Harmesh Singh

To create a table with a timestamp column in PostgreSQL, you can use the following syntax:n`nCREATE TABLE your_table_name (n column1 data_type constraint,n n timestamps timestamp DEFAULT now() NOT NULL,n n);n`

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Postgre Interview Questions

How do I connect to a postgresql database using sql developer?

1 Answers  


How secure is postgresql?

1 Answers  


How do I change the order of columns in postgresql?

1 Answers  


How to select distinct on multiple columns?

1 Answers  


What are the types of schema?

1 Answers  


What is pg_toast?

1 Answers  


How do you query pgadmin?

1 Answers  


What is character varying in postgres?

1 Answers  


What is pg_catalog in postgres?

1 Answers  


What command do you type to exit the postgresql console application?

1 Answers  


What is use of postgresql?

1 Answers  


How do I completely uninstall postgresql?

1 Answers  


Categories