Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- [geckos@csi24 ~]$ psql -h 155.1.1.169 -u postgres
- psql: invalid option -- 'u'
- Try "psql --help" for more information.
- [geckos@csi24 ~]$ psql -h 155.1.1.169 -U postgres
- psql (9.4.5, server 9.2.4)
- Type "help" for help.
- postgres=# \c andon
- psql (9.4.5, server 9.2.4)
- You are now connected to database "andon" as user "postgres".
- andon=# \dt
- List of relations
- Schema | Name | Type | Owner
- --------+---------------------+-------+----------
- public | an_operator | table | postgres
- public | an_production_order | table | postgres
- public | an_states_events | table | postgres
- public | an_stop_reason | table | postgres
- public | an_tool | table | postgres
- public | andon_user | table | postgres
- (6 rows)
- andon=# truncate table an_states_events;
- TRUNCATE TABLE
- andon=# \quit
- [geckos@csi24 ~]$
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement