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 |
How do I connect to a postgresql database using sql developer?
How secure is postgresql?
How do I change the order of columns in postgresql?
How to select distinct on multiple columns?
What are the types of schema?
What is pg_toast?
How do you query pgadmin?
What is character varying in postgres?
What is pg_catalog in postgres?
What command do you type to exit the postgresql console application?
What is use of postgresql?
How do I completely uninstall postgresql?
Oracle (3253)
SQL Server (4518)
MS Access (429)
MySQL (1402)
Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)
DB Development (113)
SQL PLSQL (3330)
MongoDB (502)
IBM Informix (50)
Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)
Database Management (1411)
Databases AllOther (288)