Skip to content

Instantly share code, notes, and snippets.

@antoniocachuan

antoniocachuan/simplecreate.sql

Created September 7, 2021 03:32
Show Gist options
  • Save antoniocachuan/5ffd1c6085b7d1551816ed08ab04b3e5 to your computer and use it in GitHub Desktop.
Save antoniocachuan/5ffd1c6085b7d1551816ed08ab04b3e5 to your computer and use it in GitHub Desktop.
Download ZIP
Simple Create for PostgreSQL
Raw
simplecreate.sql
CREATE TABLE transactions (
transaction_id serial PRIMARY KEY,
product VARCHAR ( 50 ),
category VARCHAR ( 50 ),
email VARCHAR ( 255 ),
created_on TIMESTAMP
);
insert into transactions values (1, 'soda', 'drinks', '', '2021-08-08T01:10:45')
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment