Advertisement
danielhilst

delete-andon-events.txt

Nov 25th, 2015
96
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.85 KB | None | 0 0
  1. [geckos@csi24 ~]$ psql -h 155.1.1.169 -u postgres
  2. psql: invalid option -- 'u'
  3. Try "psql --help" for more information.
  4. [geckos@csi24 ~]$ psql -h 155.1.1.169 -U postgres
  5. psql (9.4.5, server 9.2.4)
  6. Type "help" for help.
  7.  
  8. postgres=# \c andon
  9. psql (9.4.5, server 9.2.4)
  10. You are now connected to database "andon" as user "postgres".
  11. andon=# \dt
  12. List of relations
  13. Schema | Name | Type | Owner
  14. --------+---------------------+-------+----------
  15. public | an_operator | table | postgres
  16. public | an_production_order | table | postgres
  17. public | an_states_events | table | postgres
  18. public | an_stop_reason | table | postgres
  19. public | an_tool | table | postgres
  20. public | andon_user | table | postgres
  21. (6 rows)
  22.  
  23. andon=# truncate table an_states_events;
  24. TRUNCATE TABLE
  25. andon=# \quit
  26. [geckos@csi24 ~]$
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement