Advertisement
Dijit

no primary key

Jan 25th, 2017
219
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.54 KB | None | 0 0
  1. jharasym=# create table users (name varchar,age int);
  2. CREATE TABLE
  3. jharasym=# \d users
  4. Table "public.users"
  5. Column | Type | Modifiers
  6. --------+-------------------+-----------
  7. name | character varying |
  8. age | integer |
  9.  
  10. jharasym=# insert into users values ('Derecho', 25);
  11. INSERT 0 1
  12. jharasym=# insert into users values ('dijit', 27);
  13. INSERT 0 1
  14. jharasym=# select * from users;
  15. name | age
  16. ---------+-----
  17. Derecho | 25
  18. dijit | 27
  19. (2 rows)
  20.  
  21. jharasym=#
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement