Skip to content

Instantly share code, notes, and snippets.

@kernsjn

kernsjn/gist:55a7edeb9cfd926196a65f749875410a Secret

Created December 11, 2019 16:38
Show Gist options
  • Save kernsjn/55a7edeb9cfd926196a65f749875410a to your computer and use it in GitHub Desktop.
Save kernsjn/55a7edeb9cfd926196a65f749875410a to your computer and use it in GitHub Desktop.
Download ZIP
Raw
gistfile1.txt
Last login: Tue Dec 10 15:07:38 on ttys000
~ $ pgcli company_database
Server: PostgreSQL 12.1
Version: 2.1.1
Chat: https://gitter.im/dbcli/pgcli
Mail: https://groups.google.com/forum/#!forum/pgcli
Home: http://pgcli.com
nkerns@/tmp:company_database> Exception in thread completion_refresh:
Traceback (most recent call last):
File "/usr/local/opt/python/Frameworks/Python.framework/Versions/3.7/lib/python3.7/threading.py", line 926, in _bootstrap_inner
self.run()
File "/usr/local/opt/python/Frameworks/Python.framework/Versions/3.7/lib/python3.7/threading.py", line 870, in run
self._target(*self._args, **self._kwargs)
File "/usr/local/Cellar/pgcli/2.1.1_2/libexec/lib/python3.7/site-packages/pgcli/completion_refresher.py", line 65, in _bg_refresh
refresher(completer, executor)
File "/usr/local/Cellar/pgcli/2.1.1_2/libexec/lib/python3.7/site-packages/pgcli/completion_refresher.py", line 109, in refresh_tables
completer.extend_columns(executor.table_columns(), kind="tables")
File "/usr/local/Cellar/pgcli/2.1.1_2/libexec/lib/python3.7/site-packages/pgcli/pgcompleter.py", line 218, in extend_columns
for schema, relname, colname, datatype, has_default, default in column_data:
File "/usr/local/Cellar/pgcli/2.1.1_2/libexec/lib/python3.7/site-packages/pgcli/pgexecute.py", line 591, in table_columns
for row in self._columns(kinds=["r"]):
File "/usr/local/Cellar/pgcli/2.1.1_2/libexec/lib/python3.7/site-packages/pgcli/pgexecute.py", line 586, in _columns
cur.execute(sql)
psycopg2.errors.UndefinedColumn: column def.adsrc does not exist
LINE 7: def.adsrc as default
^
nkerns@/tmp:company_database> \dt
+----------+-------------+--------+---------+
| Schema | Name | Type | Owner |
|----------+-------------+--------+---------|
| public | departments | table | nkerns |
| public | employees | table | nkerns |
+----------+-------------+--------+---------+
SELECT 2
Time: 0.017s
nkerns@/tmp:company_database> pgcli company-database
syntax error at or near "pgcli"
LINE 1: pgcli company-database
^
Time: 0.048s
nkerns@/tmp:company_database> pgcli company_database
syntax error at or near "pgcli"
LINE 1: pgcli company_database
^
Time: 0.001s
nkerns@/tmp:company_database> /dt departments
syntax error at or near "/"
LINE 1: /dt departments
^
Time: 0.001s
nkerns@/tmp:company_database> select * from departments
+------------------+------------+------+
| departmentname | building | id |
|------------------+------------+------|
+------------------+------------+------+
SELECT 0
Time: 0.017s
nkerns@/tmp:company_database> INSERT INTO departments (deparmentname, building)
values ('information technology', 'Building 1')
column "deparmentname" of relation "departments" does not exist
LINE 1: INSERT INTO departments (deparmentname, building) values ('...
^
Time: 0.001s
nkerns@/tmp:company_database> INSERT INTO departments (departmentname, building
) values ('information technology', 'Building 1')
INSERT 0 1
Time: 0.046s
nkerns@/tmp:company_database> INSERT INTO departments (departmentname, building
) values ('Admin', 'Building 2')
INSERT 0 1
Time: 0.040s
nkerns@/tmp:company_database> INSERT INTO departments (departmentname, building
) values ('Executive', 'Building 3')
INSERT 0 1
Time: 0.041s
nkerns@/tmp:company_database> select * from employees
+--------------+----------+-------------------------------+-------------------+-
| full_name | salary | job_position | phone_extension |
|--------------+----------+-------------------------------+-------------------+-
| Jill Jones | 55000 | Database Admin | 113 |
| Sam Baker | 115000 | CFO | 102 |
| Nikki Kerns | 120000 | CEO | 100 |
| Thomas James | 30000 | Director of First Impressions | 150 |
| Jim Cook | 450 | Software Developer | 120 |
| Bob Smith | 500 | cook | 123 |
+--------------+----------+-------------------------------+-------------------+-
SELECT 6
(END)...skipping...
+--------------+----------+-------------------------------+-------------------+-
| full_name | salary | job_position | phone_extension |
|--------------+----------+-------------------------------+-------------------+-
| Jill Jones | 55000 | Database Admin | 113 |
| Sam Baker | 115000 | CFO | 102 |
| Nikki Kerns | 120000 | CEO | 100 |
| Thomas James | 30000 | Director of First Impressions | 150 |
| Jim Cook | 450 | Software Developer | 120 |
| Bob Smith | 500 | cook | 123 |
+--------------+----------+-------------------------------+-------------------+-
SELECT 6
~
~
~
~
~
~
~
~
~
~
~
~
~
(END)...skipping...
+--------------+----------+-------------------------------+-------------------+-------------+------+-----------------------+-----------------+
| full_name | salary | job_position | phone_extension | part_time | id | parking_spot_number | deparmtner_id |
|--------------+----------+-------------------------------+-------------------+-------------+------+-----------------------+-----------------|
| Jill Jones | 55000 | Database Admin | 113 | False | 2 | <null> | <null> |
| Sam Baker | 115000 | CFO | 102 | False | 3 | <null> | <null> |
| Nikki Kerns | 120000 | CEO | 100 | False | 4 | <null> | <null> |
| Thomas James | 30000 | Director of First Impressions | 150 | False | 5 | <null> | <null> |
| Jim Cook | 450 | Software Developer | 120 | False | 6 | <null> | <null> |
| Bob Smith | 500 | cook | 123 | False | 1 | <null> | <null> |
+--------------+----------+-------------------------------+-------------------+-------------+------+-----------------------+-----------------+
SELECT 6
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
Time: 0.017s
nkerns@/tmp:company_database> ALTER TABLE employees DROP COLUMN deparmtner_id;
You're about to run a destructive command.
Do you want to proceed? (y/n): y
Your call!
ALTER TABLE
Time: 0.010s
nkerns@/tmp:company_database> Exception in thread completion_refresh:
Traceback (most recent call last):
File "/usr/local/opt/python/Frameworks/Python.framework/Versions/3.7/lib/python3.7/threading.py", line 926, in _bootstrap_inner
self.run()
File "/usr/local/opt/python/Frameworks/Python.framework/Versions/3.7/lib/python3.7/threading.py", line 870, in run
self._target(*self._args, **self._kwargs)
File "/usr/local/Cellar/pgcli/2.1.1_2/libexec/lib/python3.7/site-packages/pgcli/completion_refresher.py", line 65, in _bg_refresh
refresher(completer, executor)
File "/usr/local/Cellar/pgcli/2.1.1_2/libexec/lib/python3.7/site-packages/pgcli/completion_refresher.py", line 109, in refresh_tables
completer.extend_columns(executor.table_columns(), kind="tables")
File "/usr/local/Cellar/pgcli/2.1.1_2/libexec/lib/python3.7/site-packages/pgcli/pgcompleter.py", line 218, in extend_columns
for schema, relname, colname, datatype, has_default, default in column_data:
File "/usr/local/Cellar/pgcli/2.1.1_2/libexec/lib/python3.7/site-packages/pgcli/pgexecute.py", line 591, in table_columns
for row in self._columns(kinds=["r"]):
File "/usr/local/Cellar/pgcli/2.1.1_2/libexec/lib/python3.7/site-packages/pgcli/pgexecute.py", line 586, in _columns
cur.execute(sql)
psycopg2.errors.UndefinedColumn: column def.adsrc does not exist
LINE 7: def.adsrc as default
^
nkerns@/tmp:company_database> select * from employees
+--------------+----------+-------------------------------+-------------------+-------------+------+-----------------------+
| full_name | salary | job_position | phone_extension | part_time | id | parking_spot_number |
|--------------+----------+-------------------------------+-------------------+-------------+------+-----------------------|
| Jill Jones | 55000 | Database Admin | 113 | False | 2 | <null> |
| Sam Baker | 115000 | CFO | 102 | False | 3 | <null> |
| Nikki Kerns | 120000 | CEO | 100 | False | 4 | <null> |
| Thomas James | 30000 | Director of First Impressions | 150 | False | 5 | <null> |
| Jim Cook | 450 | Software Developer | 120 | False | 6 | <null> |
| Bob Smith | 500 | cook | 123 | False | 1 | <null> |
+--------------+----------+-------------------------------+-------------------+-------------+------+-----------------------+
SELECT 6
Time: 0.014s
nkerns@/tmp:company_database> ALTER TABLE employees ADD COLUMN department_id INTEGER
You're about to run a destructive command.
Do you want to proceed? (y/n): y
Your call!
ALTER TABLE
Time: 0.007s
nkerns@/tmp:company_database> Exception in thread completion_refresh:
Traceback (most recent call last):
File "/usr/local/opt/python/Frameworks/Python.framework/Versions/3.7/lib/python3.7/threading.py", line 926, in _bootstrap_inner
self.run()
File "/usr/local/opt/python/Frameworks/Python.framework/Versions/3.7/lib/python3.7/threading.py", line 870, in run
self._target(*self._args, **self._kwargs)
File "/usr/local/Cellar/pgcli/2.1.1_2/libexec/lib/python3.7/site-packages/pgcli/completion_refresher.py", line 65, in _bg_refresh
refresher(completer, executor)
File "/usr/local/Cellar/pgcli/2.1.1_2/libexec/lib/python3.7/site-packages/pgcli/completion_refresher.py", line 109, in refresh_tables
completer.extend_columns(executor.table_columns(), kind="tables")
File "/usr/local/Cellar/pgcli/2.1.1_2/libexec/lib/python3.7/site-packages/pgcli/pgcompleter.py", line 218, in extend_columns
for schema, relname, colname, datatype, has_default, default in column_data:
File "/usr/local/Cellar/pgcli/2.1.1_2/libexec/lib/python3.7/site-packages/pgcli/pgexecute.py", line 591, in table_columns
for row in self._columns(kinds=["r"]):
File "/usr/local/Cellar/pgcli/2.1.1_2/libexec/lib/python3.7/site-packages/pgcli/pgexecute.py", line 586, in _columns
cur.execute(sql)
psycopg2.errors.UndefinedColumn: column def.adsrc does not exist
LINE 7: def.adsrc as default
^
nkerns@/tmp:company_database> select * from employees
+--------------+----------+-------------------------------+-------------------+-------------+------+-----------------------+-----------------+
| full_name | salary | job_position | phone_extension | part_time | id | parking_spot_number | department_id |
|--------------+----------+-------------------------------+-------------------+-------------+------+-----------------------+-----------------|
| Jill Jones | 55000 | Database Admin | 113 | False | 2 | <null> | <null> |
| Sam Baker | 115000 | CFO | 102 | False | 3 | <null> | <null> |
| Nikki Kerns | 120000 | CEO | 100 | False | 4 | <null> | <null> |
| Thomas James | 30000 | Director of First Impressions | 150 | False | 5 | <null> | <null> |
| Jim Cook | 450 | Software Developer | 120 | False | 6 | <null> | <null> |
| Bob Smith | 500 | cook | 123 | False | 1 | <null> | <null> |
+--------------+----------+-------------------------------+-------------------+-------------+------+-----------------------+-----------------+
SELECT 6
Time: 0.016s
nkerns@/tmp:company_database> select * from departments
+------------------------+------------+------+
| departmentname | building | id |
|------------------------+------------+------|
| information technology | Building 1 | 1 |
| Admin | Building 2 | 2 |
| Executive | Building 3 | 3 |
+------------------------+------------+------+
SELECT 3
Time: 0.015s
nkerns@/tmp:company_database> update employees set department_id = 1 where id = 2;
UPDATE 1
Time: 0.042s
nkerns@/tmp:company_database> select * from employees
+--------------+----------+-------------------------------+-------------------+-------------+------+-----------------------+-----------------+
| full_name | salary | job_position | phone_extension | part_time | id | parking_spot_number | department_id |
|--------------+----------+-------------------------------+-------------------+-------------+------+-----------------------+-----------------|
| Sam Baker | 115000 | CFO | 102 | False | 3 | <null> | <null> |
| Nikki Kerns | 120000 | CEO | 100 | False | 4 | <null> | <null> |
| Thomas James | 30000 | Director of First Impressions | 150 | False | 5 | <null> | <null> |
| Jim Cook | 450 | Software Developer | 120 | False | 6 | <null> | <null> |
| Bob Smith | 500 | cook | 123 | False | 1 | <null> | <null> |
| Jill Jones | 55000 | Database Admin | 113 | False | 2 | <null> | 1 |
+--------------+----------+-------------------------------+-------------------+-------------+------+-----------------------+-----------------+
SELECT 6
Time: 0.015s
nkerns@/tmp:company_database> update employees set department_id = 1 where id = 6;
UPDATE 1
Time: 0.041s
nkerns@/tmp:company_database> update employees set department_id = 2 where id = 1;
UPDATE 1
Time: 0.041s
nkerns@/tmp:company_database> update employees set department_id = 2 where id = 5;
UPDATE 1
Time: 0.042s
nkerns@/tmp:company_database> select * from employees
+--------------+----------+-------------------------------+-------------------+-------------+------+-----------------------+-----------------+
| full_name | salary | job_position | phone_extension | part_time | id | parking_spot_number | department_id |
|--------------+----------+-------------------------------+-------------------+-------------+------+-----------------------+-----------------|
| Sam Baker | 115000 | CFO | 102 | False | 3 | <null> | <null> |
| Nikki Kerns | 120000 | CEO | 100 | False | 4 | <null> | <null> |
| Jill Jones | 55000 | Database Admin | 113 | False | 2 | <null> | 1 |
| Jim Cook | 450 | Software Developer | 120 | False | 6 | <null> | 1 |
| Bob Smith | 500 | cook | 123 | False | 1 | <null> | 2 |
| Thomas James | 30000 | Director of First Impressions | 150 | False | 5 | <null> | 2 |
+--------------+----------+-------------------------------+-------------------+-------------+------+-----------------------+-----------------+
SELECT 6
Time: 0.017s
nkerns@/tmp:company_database> update employees set department_id = 3 where id = 3;
UPDATE 1
Time: 0.043s
nkerns@/tmp:company_database> update employees set department_id = 3 where id = 4;
UPDATE 1
Time: 0.040s
nkerns@/tmp:company_database> select * from employees
+--------------+----------+-------------------------------+-------------------+-------------+------+-----------------------+-----------------+
| full_name | salary | job_position | phone_extension | part_time | id | parking_spot_number | department_id |
|--------------+----------+-------------------------------+-------------------+-------------+------+-----------------------+-----------------|
| Jill Jones | 55000 | Database Admin | 113 | False | 2 | <null> | 1 |
| Jim Cook | 450 | Software Developer | 120 | False | 6 | <null> | 1 |
| Bob Smith | 500 | cook | 123 | False | 1 | <null> | 2 |
| Thomas James | 30000 | Director of First Impressions | 150 | False | 5 | <null> | 2 |
| Sam Baker | 115000 | CFO | 102 | False | 3 | <null> | 3 |
| Nikki Kerns | 120000 | CEO | 100 | False | 4 | <null> | 3 |
+--------------+----------+-------------------------------+-------------------+-------------+------+-----------------------+-----------------+
SELECT 6
Time: 0.016s
nkerns@/tmp:company_database> CREATE TABLE orders (order_number TEXT, id SERIAL
PRIMARY KEY, date_placed TEXT, email TEXT)
CREATE TABLE
Time: 0.048s
nkerns@/tmp:company_database> Exception in thread completion_refresh:
Traceback (most recent call last):
File "/usr/local/opt/python/Frameworks/Python.framework/Versions/3.7/lib/python3.7/threading.py", line 926, in _bootstrap_inner
self.run()mpletion: ON [F3] Multiline: OFF [F4] Emacs-mode Refreshing
File "/usr/local/opt/python/Frameworks/Python.framework/Versions/3.7/lib/python3.7/threading.py", line 870, in run
self._target(*self._args, **self._kwargs)
File "/usr/local/Cellar/pgcli/2.1.1_2/libexec/lib/python3.7/site-packages/pgcli/completion_refresher.py", line 65, in _bg_refresh
refresher(completer, executor)
File "/usr/local/Cellar/pgcli/2.1.1_2/libexec/lib/python3.7/site-packages/pgcli/completion_refresher.py", line 109, in refresh_tables
completer.extend_columns(executor.table_columns(), kind="tables")
File "/usr/local/Cellar/pgcli/2.1.1_2/libexec/lib/python3.7/site-packages/pgcli/pgcompleter.py", line 218, in extend_columns
for schema, relname, colname, datatype, has_default, default in column_data:
File "/usr/local/Cellar/pgcli/2.1.1_2/libexec/lib/python3.7/site-packages/pgcli/pgexecute.py", line 591, in table_columns
for row in self._columns(kinds=["r"]):
File "/usr/local/Cellar/pgcli/2.1.1_2/libexec/lib/python3.7/site-packages/pgcli/pgexecute.py", line 586, in _columns
cur.execute(sql)
psycopg2.errors.UndefinedColumn: column def.adsrc does not exist
LINE 7: def.adsrc as default
^
nkerns@/tmp:company_database> select * from orders
+----------------+------+---------------+---------+
| order_number | id | date_placed | email |
|----------------+------+---------------+---------|
+----------------+------+---------------+---------+
SELECT 0
Time: 0.014s
nkerns@/tmp:company_database> CREATE TABLE products (id SERIAL PRIMARY KEY, pric
e INT, name TEXT, description TEXT, number_in_stock INT)
CREATE TABLE
Time: 0.045s
nkerns@/tmp:company_database> Exception in thread completion_refresh:
Traceback (most recent call last):
File "/usr/local/opt/python/Frameworks/Python.framework/Versions/3.7/lib/python3.7/threading.py", line 926, in _bootstrap_inner
self.run()mpletion: ON [F3] Multiline: OFF [F4] Emacs-mode Refreshing
File "/usr/local/opt/python/Frameworks/Python.framework/Versions/3.7/lib/python3.7/threading.py", line 870, in run
self._target(*self._args, **self._kwargs)
File "/usr/local/Cellar/pgcli/2.1.1_2/libexec/lib/python3.7/site-packages/pgcli/completion_refresher.py", line 65, in _bg_refresh
refresher(completer, executor)
File "/usr/local/Cellar/pgcli/2.1.1_2/libexec/lib/python3.7/site-packages/pgcli/completion_refresher.py", line 109, in refresh_tables
completer.extend_columns(executor.table_columns(), kind="tables")
File "/usr/local/Cellar/pgcli/2.1.1_2/libexec/lib/python3.7/site-packages/pgcli/pgcompleter.py", line 218, in extend_columns
for schema, relname, colname, datatype, has_default, default in column_data:
File "/usr/local/Cellar/pgcli/2.1.1_2/libexec/lib/python3.7/site-packages/pgcli/pgexecute.py", line 591, in table_columns
for row in self._columns(kinds=["r"]):
File "/usr/local/Cellar/pgcli/2.1.1_2/libexec/lib/python3.7/site-packages/pgcli/pgexecute.py", line 586, in _columns
cur.execute(sql)
psycopg2.errors.UndefinedColumn: column def.adsrc does not exist
LINE 7: def.adsrc as default
^
nkerns@/tmp:company_database> DELETE TABLE orders
You're about to run a destructive command.
Do you want to proceed? (y/n): y
Your call!
syntax error at or near "TABLE"
LINE 1: DELETE TABLE orders
^
Time: 0.006s
nkerns@/tmp:company_database> DELETE TABLE orders;
You're about to run a destructive command.
Do you want to proceed? (y/n): y
Your call!
syntax error at or near "TABLE"
LINE 1: DELETE TABLE orders
^
Time: 0.001s
nkerns@/tmp:company_database> DROP TABLE orders;
You're about to run a destructive command.
Do you want to proceed? (y/n): y
Your call!
DROP TABLE
Time: 0.009s
nkerns@/tmp:company_database> Exception in thread completion_refresh:
Traceback (most recent call last):
File "/usr/local/opt/python/Frameworks/Python.framework/Versions/3.7/lib/python3.7/threading.py", line 926, in _bootstrap_inner
self.run()mpletion: ON [F3] Multiline: OFF [F4] Emacs-mode Refreshing
File "/usr/local/opt/python/Frameworks/Python.framework/Versions/3.7/lib/python3.7/threading.py", line 870, in run
self._target(*self._args, **self._kwargs)
File "/usr/local/Cellar/pgcli/2.1.1_2/libexec/lib/python3.7/site-packages/pgcli/completion_refresher.py", line 65, in _bg_refresh
refresher(completer, executor)
File "/usr/local/Cellar/pgcli/2.1.1_2/libexec/lib/python3.7/site-packages/pgcli/completion_refresher.py", line 109, in refresh_tables
completer.extend_columns(executor.table_columns(), kind="tables")
File "/usr/local/Cellar/pgcli/2.1.1_2/libexec/lib/python3.7/site-packages/pgcli/pgcompleter.py", line 218, in extend_columns
for schema, relname, colname, datatype, has_default, default in column_data:
File "/usr/local/Cellar/pgcli/2.1.1_2/libexec/lib/python3.7/site-packages/pgcli/pgexecute.py", line 591, in table_columns
for row in self._columns(kinds=["r"]):
File "/usr/local/Cellar/pgcli/2.1.1_2/libexec/lib/python3.7/site-packages/pgcli/pgexecute.py", line 586, in _columns
cur.execute(sql)
psycopg2.errors.UndefinedColumn: column def.adsrc does not exist
LINE 7: def.adsrc as default
^
nkerns@/tmp:company_database> CREATE TABLE orders (order_number TEXT NOT NULL, i
d SERIAL PRIMARY KEY, date_placed DATE, email TEXT);
CREATE TABLE
Time: 0.048s
nkerns@/tmp:company_database> Exception in thread completion_refresh:
Traceback (most recent call last):
File "/usr/local/opt/python/Frameworks/Python.framework/Versions/3.7/lib/python3.7/threading.py", line 926, in _bootstrap_inner
self.run()mpletion: ON [F3] Multiline: OFF [F4] Emacs-mode Refreshing
File "/usr/local/opt/python/Frameworks/Python.framework/Versions/3.7/lib/python3.7/threading.py", line 870, in run
self._target(*self._args, **self._kwargs)
File "/usr/local/Cellar/pgcli/2.1.1_2/libexec/lib/python3.7/site-packages/pgcli/completion_refresher.py", line 65, in _bg_refresh
refresher(completer, executor)
File "/usr/local/Cellar/pgcli/2.1.1_2/libexec/lib/python3.7/site-packages/pgcli/completion_refresher.py", line 109, in refresh_tables
completer.extend_columns(executor.table_columns(), kind="tables")
File "/usr/local/Cellar/pgcli/2.1.1_2/libexec/lib/python3.7/site-packages/pgcli/pgcompleter.py", line 218, in extend_columns
for schema, relname, colname, datatype, has_default, default in column_data:
File "/usr/local/Cellar/pgcli/2.1.1_2/libexec/lib/python3.7/site-packages/pgcli/pgexecute.py", line 591, in table_columns
for row in self._columns(kinds=["r"]):
File "/usr/local/Cellar/pgcli/2.1.1_2/libexec/lib/python3.7/site-packages/pgcli/pgexecute.py", line 586, in _columns
cur.execute(sql)
psycopg2.errors.UndefinedColumn: column def.adsrc does not exist
LINE 7: def.adsrc as default
^
nkerns@/tmp:company_database> select * from orders
+----------------+------+---------------+---------+
| order_number | id | date_placed | email |
|----------------+------+---------------+---------|
+----------------+------+---------------+---------+
SELECT 0
Time: 0.054s
nkerns@/tmp:company_database> CREATE TABLE product_orders (id SERIAL PRIMARY KEY
, orders_id INTEGER REFERENCES orders(id), products_id INTEGER REFERENCES produ
cts(id));
CREATE TABLE
Time: 0.088s
nkerns@/tmp:company_database> Exception in thread completion_refresh:
Traceback (most recent call last):
File "/usr/local/opt/python/Frameworks/Python.framework/Versions/3.7/lib/python3.7/threading.py", line 926, in _bootstrap_inner
self.run()mpletion: ON [F3] Multiline: OFF [F4] Emacs-mode Refreshing
File "/usr/local/opt/python/Frameworks/Python.framework/Versions/3.7/lib/python3.7/threading.py", line 870, in run
self._target(*self._args, **self._kwargs)
File "/usr/local/Cellar/pgcli/2.1.1_2/libexec/lib/python3.7/site-packages/pgcli/completion_refresher.py", line 65, in _bg_refresh
refresher(completer, executor)
File "/usr/local/Cellar/pgcli/2.1.1_2/libexec/lib/python3.7/site-packages/pgcli/completion_refresher.py", line 109, in refresh_tables
completer.extend_columns(executor.table_columns(), kind="tables")
File "/usr/local/Cellar/pgcli/2.1.1_2/libexec/lib/python3.7/site-packages/pgcli/pgcompleter.py", line 218, in extend_columns
for schema, relname, colname, datatype, has_default, default in column_data:
File "/usr/local/Cellar/pgcli/2.1.1_2/libexec/lib/python3.7/site-packages/pgcli/pgexecute.py", line 591, in table_columns
for row in self._columns(kinds=["r"]):
File "/usr/local/Cellar/pgcli/2.1.1_2/libexec/lib/python3.7/site-packages/pgcli/pgexecute.py", line 586, in _columns
cur.execute(sql)
psycopg2.errors.UndefinedColumn: column def.adsrc does not exist
LINE 7: def.adsrc as default
^
nkerns@/tmp:company_database> select * from employees
+--------------+----------+-------------------------------+-------------------+-
| full_name | salary | job_position | phone_extension |
|--------------+----------+-------------------------------+-------------------+-
| Jill Jones | 55000 | Database Admin | 113 |
| Jim Cook | 450 | Software Developer | 120 |
| Bob Smith | 500 | cook | 123 |
| Thomas James | 30000 | Director of First Impressions | 150 |
| Sam Baker | 115000 | CFO | 102 |
| Nikki Kerns | 120000 | CEO | 100 |
+--------------+----------+-------------------------------+-------------------+-
SELECT 6
Time: 0.058s
nkerns@/tmp:company_database> select * from departments where department_id =1;
column "department_id" does not exist
LINE 1: select * from departments where department_id =1
^
Time: 0.001s
nkerns@/tmp:company_database> select * from departments where id =1;
+------------------------+------------+------+
| departmentname | building | id |
|------------------------+------------+------|
| information technology | Building 1 | 1 |
+------------------------+------------+------+
SELECT 1
Time: 0.013s
nkerns@/tmp:company_database> select phone_extension from departments join emplo
yees on department.id = employees.department_id where departments.departmentnam
e = 'Admin';
missing FROM-clause entry for table "department"
LINE 1: ...hone_extension from departments join employees on department...
^
Time: 0.001s
nkerns@/tmp:company_database> select phone_extension from departments join emplo
yees on departments.id = employees.department_id where departments.departmentna
me = 'Admin';
+-------------------+
| phone_extension |
|-------------------|
| 123 |
| 150 |
+-------------------+
SELECT 2
Time: 0.014s
nkerns@/tmp:company_database> select * from orders
+----------------+------+---------------+---------+
| order_number | id | date_placed | email |
|----------------+------+---------------+---------|
+----------------+------+---------------+---------+
SELECT 0
Time: 0.014s
nkerns@/tmp:company_database> INSERT INTO orders (order_number, date_placed, em
ail) values ('12', '12-10-2019', 'email@email.com');
INSERT 0 1
Time: 0.044s
nkerns@/tmp:company_database> INSERT INTO orders (order_number, date_placed, em
ail) values ('13', '12-11-2019', 'email2@email.com');
INSERT 0 1
Time: 0.041s
nkerns@/tmp:company_database> INSERT INTO orders (order_number, date_placed, em
ail) values ('14', '12-11-2019', 'email3@email.com');
INSERT 0 1
Time: 0.042s
nkerns@/tmp:company_database> select * from products
+------+---------+--------+---------------+-------------------+
| id | price | name | description | number_in_stock |
|------+---------+--------+---------------+-------------------|
+------+---------+--------+---------------+-------------------+
SELECT 0
Time: 0.016s
nkerns@/tmp:company_database> INSERT INTO products (price, name, description, nu
mber_in_stock) VALUES (15, 'Widget', 'Widgent is good', 2)
INSERT 0 1
Time: 0.041s
nkerns@/tmp:company_database> INSERT INTO products (price, name, description, nu
mber_in_stock) VALUES (22, 'Thing', 'Thing is great', 1)
INSERT 0 1
Time: 0.041s
nkerns@/tmp:company_database> INSERT INTO products (price, name, description, nu
mber_in_stock) VALUES (5, 'Stuff', 'Stuff is okay', 6)
INSERT 0 1
Time: 0.040s
nkerns@/tmp:company_database> select * from product_order
relation "product_order" does not exist
LINE 1: select * from product_order
^
Time: 0.001s
nkerns@/tmp:company_database> select * from product_orders
+------+-------------+---------------+
| id | orders_id | products_id |
|------+-------------+---------------|
+------+-------------+---------------+
SELECT 0
Time: 0.056s
nkerns@/tmp:company_database> INSERT INTO product_orders (orders_id, products_id
) VALUES (12, 15);
insert or update on table "product_orders" violates foreign key constraint "prod
DETAIL: Key (orders_id)=(12) is not present in table "orders".
Time: 0.002s
nkerns@/tmp:company_database> select * from orders
+----------------+------+---------------+------------------+
| order_number | id | date_placed | email |
|----------------+------+---------------+------------------|
| 12 | 1 | 2019-12-10 | email@email.com |
| 13 | 2 | 2019-12-11 | email2@email.com |
| 14 | 3 | 2019-12-11 | email3@email.com |
+----------------+------+---------------+------------------+
SELECT 3
Time: 0.014s
nkerns@/tmp:company_database> select * from products
+------+---------+--------+-----------------+-------------------+
| id | price | name | description | number_in_stock |
|------+---------+--------+-----------------+-------------------|
| 1 | 15 | Widget | Widgent is good | 2 |
| 2 | 22 | Thing | Thing is great | 1 |
| 3 | 5 | Stuff | Stuff is okay | 6 |
+------+---------+--------+-----------------+-------------------+
SELECT 3
Time: 0.014s
nkerns@/tmp:company_database> INSERT INTO product_orders (orders_id, products_id
) VALUES (1,1);
INSERT 0 1
Time: 0.042s
nkerns@/tmp:company_database> SELECT * FROM orders where
syntax error at end of input
LINE 1: SELECT * FROM orders where
^
Time: 0.044s
nkerns@/tmp:company_database> SELECT phone_extension FROM departments JOIN emplo
yees ON departments.id = employees.department_id WHERE departmentname = 'Admin'
+-------------------+
| phone_extension |
|-------------------|
| 123 |
| 150 |
+-------------------+
SELECT 2
Time: 0.014s
nkerns@/tmp:company_database> select * from departments
+------------------------+------------+------+
| departmentname | building | id |
|------------------------+------------+------|
| information technology | Building 1 | 1 |
| Admin | Building 2 | 2 |
| Executive | Building 3 | 3 |
+------------------------+------------+------+
SELECT 3
Time: 0.015s
nkerns@/tmp:company_database> select * from employees
+--------------+----------+-------------------------------+-------------------+-
| full_name | salary | job_position | phone_extension |
|--------------+----------+-------------------------------+-------------------+-
| Jill Jones | 55000 | Database Admin | 113 |
| Jim Cook | 450 | Software Developer | 120 |
| Bob Smith | 500 | cook | 123 |
| Thomas James | 30000 | Director of First Impressions | 150 |
| Sam Baker | 115000 | CFO | 102 |
| Nikki Kerns | 120000 | CEO | 100 |
+--------------+----------+-------------------------------+-------------------+-
SELECT 6
Time: 0.018s
nkerns@/tmp:company_database> select * from product_orders
+------+-------------+---------------+
| id | orders_id | products_id |
|------+-------------+---------------|
| 2 | 1 | 1 |
+------+-------------+---------------+
SELECT 1
Time: 0.014s
nkerns@/tmp:company_database>
Time: 0.000s
nkerns@/tmp:company_database> SELECT order.id FROM
syntax error at or near "."
LINE 1: SELECT order.id FROM
^
Time: 0.001s
nkerns@/tmp:company_database> SELECT orders.id FROM orders join product_orders o
n product_orders.orders.id = orders.id
invalid reference to FROM-clause entry for table "orders"
LINE 1: ...LECT orders.id FROM orders join product_orders on product_or...
^
HINT: There is an entry for table "orders", but it cannot be referenced from th
(END)
invalid reference to FROM-clause entry for table "orders"
LINE 1: ...LECT orders.id FROM orders join product_orders on product_or...
^
HINT: There is an entry for table "orders", but it cannot be referenced from this
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
(END)
invalid reference to FROM-clause entry for table "orders"
LINE 1: ...LECT orders.id FROM orders join product_orders on product_or...
^
HINT: There is an entry for table "orders", but it cannot be referenced from this part of t
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
(END)
invalid reference to FROM-clause entry for table "orders"
LINE 1: ...LECT orders.id FROM orders join product_orders on product_or...
^
HINT: There is an entry for table "orders", but it cannot be referenced from this part of the q
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
(END)
invalid reference to FROM-clause entry for table "orders"
LINE 1: ...LECT orders.id FROM orders join product_orders on product_or...
^
HINT: There is an entry for table "orders", but it cannot be referenced from this part of the query
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
(END)
invalid reference to FROM-clause entry for table "orders"
LINE 1: ...LECT orders.id FROM orders join product_orders on product_or...
^
HINT: There is an entry for table "orders", but it cannot be referenced from this part of the query.
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
(END)
invalid reference to FROM-clause entry for table "orders"
LINE 1: ...LECT orders.id FROM orders join product_orders on product_or...
^
HINT: There is an entry for table "orders", but it cannot be referenced from this part of the query.
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
(END)
invalid reference to FROM-clause entry for table "orders"
LINE 1: ...LECT orders.id FROM orders join product_orders on product_or...
^
HINT: There is an entry for table "orders", but it cannot be referenced from this part of the query.
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
(END)
invalid reference to FROM-clause entry for table "orders"
LINE 1: ...LECT orders.id FROM orders join product_orders on product_or...
^
HINT: There is an entry for table "orders", but it cannot be referenced from this part of the query.
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
(END)
invalid reference to FROM-clause entry for table "orders"
LINE 1: ...LECT orders.id FROM orders join product_orders on product_or...
^
HINT: There is an entry for table "orders", but it cannot be referenced from this part of the query.
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
(END)
invalid reference to FROM-clause entry for table "orders"
LINE 1: ...LECT orders.id FROM orders join product_orders on product_or...
^
HINT: There is an entry for table "orders", but it cannot be referenced from this part of the query.
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
(END)
invalid reference to FROM-clause entry for table "orders"
LINE 1: ...LECT orders.id FROM orders join product_orders on product_or...
^
HINT: There is an entry for table "orders", but it cannot be referenced from this part of the query.
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
(END)
invalid reference to FROM-clause entry for table "orders"
LINE 1: ...LECT orders.id FROM orders join product_orders on product_or...
^
HINT: There is an entry for table "orders", but it cannot be referenced from this part of the query.
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
Time: 0.002s
nkerns@/tmp:company_database> SELECT orders.id FROM orders join product_orders on product_orders.orders.id = orders.id
invalid reference to FROM-clause entry for table "orders"
LINE 1: ...LECT orders.id FROM orders join product_orders on product_or...
^
HINT: There is an entry for table "orders", but it cannot be referenced from this part of the query.
Time: 0.002s
nkerns@/tmp:company_database> select * from orders
+----------------+------+---------------+------------------+
| order_number | id | date_placed | email |
|----------------+------+---------------+------------------|
| 12 | 1 | 2019-12-10 | email@email.com |
| 13 | 2 | 2019-12-11 | email2@email.com |
| 14 | 3 | 2019-12-11 | email3@email.com |
+----------------+------+---------------+------------------+
SELECT 3
Time: 0.014s
nkerns@/tmp:company_database> SELECT orders.id
missing FROM-clause entry for table "orders"
LINE 1: SELECT orders.id
^
Time: 0.001s
nkerns@/tmp:company_database> select * from orders_id
relation "orders_id" does not exist
LINE 1: select * from orders_id
^
Time: 0.001s
nkerns@/tmp:company_database> select * from product_orders
+------+-------------+---------------+
| id | orders_id | products_id |
|------+-------------+---------------|
| 2 | 1 | 1 |
+------+-------------+---------------+
SELECT 1
Time: 0.013s
nkerns@/tmp:company_database> select * from orders_id
relation "orders_id" does not exist
LINE 1: select * from orders_id
^
Time: 0.001s
nkerns@/tmp:company_database> select orders_id
column "orders_id" does not exist
LINE 1: select orders_id
^
Time: 0.001s
nkerns@/tmp:company_database> SELECT orders_id from product_orders;'
+-------------+
| orders_id |
|-------------|
| 1 |
+-------------+
SELECT 1
unterminated quoted string at or near "'"
LINE 1: '
^
Time: 0.053s
nkerns@/tmp:company_database> SELECT orders_id from product_orders;
+-------------+
| orders_id |
|-------------|
| 1 |
+-------------+
SELECT 1
Time: 0.012s
nkerns@/tmp:company_database> select * from product_orders
+------+-------------+---------------+
| id | orders_id | products_id |
|------+-------------+---------------|
| 2 | 1 | 1 |
+------+-------------+---------------+
SELECT 1
Time: 0.014s
nkerns@/tmp:company_database> INSERT INTO product_orders (orders_id, products_id) VALUES (2,2);
INSERT 0 1
Time: 0.041s
nkerns@/tmp:company_database> select * from product_orders
+------+-------------+---------------+
| id | orders_id | products_id |
|------+-------------+---------------|
| 2 | 1 | 1 |
| 3 | 2 | 2 |
+------+-------------+---------------+
SELECT 2
Time: 0.013s
nkerns@/tmp:company_database> select * from orders
+----------------+------+---------------+------------------+
| order_number | id | date_placed | email |
|----------------+------+---------------+------------------|
| 12 | 1 | 2019-12-10 | email@email.com |
| 13 | 2 | 2019-12-11 | email2@email.com |
| 14 | 3 | 2019-12-11 | email3@email.com |
+----------------+------+---------------+------------------+
SELECT 3
Time: 0.015s
nkerns@/tmp:company_database> select * from products
+------+---------+--------+-----------------+-------------------+
| id | price | name | description | number_in_stock |
|------+---------+--------+-----------------+-------------------|
| 1 | 15 | Widget | Widgent is good | 2 |
| 2 | 22 | Thing | Thing is great | 1 |
| 3 | 5 | Stuff | Stuff is okay | 6 |
+------+---------+--------+-----------------+-------------------+
SELECT 3
Time: 0.013s
nkerns@/tmp:company_database> select * from employees
+--------------+----------+-------------------------------+-------------------+-------------+------+-------------------
| full_name | salary | job_position | phone_extension | part_time | id | parking_spot_numbe
|--------------+----------+-------------------------------+-------------------+-------------+------+-------------------
| Jill Jones | 55000 | Database Admin | 113 | False | 2 | <null>
| Jim Cook | 450 | Software Developer | 120 | False | 6 | <null>
| Bob Smith | 500 | cook | 123 | False | 1 | <null>
| Thomas James | 30000 | Director of First Impressions | 150 | False | 5 | <null>
| Sam Baker | 115000 | CFO | 102 | False | 3 | <null>
| Nikki Kerns | 120000 | CEO | 100 | False | 4 | <null>
+--------------+----------+-------------------------------+-------------------+-------------+------+-------------------
SELECT 6
Time: 0.015s
nkerns@/tmp:company_database> select * from departments
+------------------------+------------+------+
| departmentname | building | id |
|------------------------+------------+------|
| information technology | Building 1 | 1 |
| Admin | Building 2 | 2 |
| Executive | Building 3 | 3 |
+------------------------+------------+------+
SELECT 3
Time: 0.015s
nkerns@/tmp:company_database> select 8 from product_orders
+------------+
| ?column? |
|------------|
| 8 |
| 8 |
+------------+
SELECT 2
Time: 0.014s
nkerns@/tmp:company_database> select * from product_orders
+------+-------------+---------------+
| id | orders_id | products_id |
|------+-------------+---------------|
| 2 | 1 | 1 |
| 3 | 2 | 2 |
+------+-------------+---------------+
SELECT 2
Time: 0.014s
nkerns@/tmp:company_database> DELETE FROM product_orders WHERE product_id =1;
You're about to run a destructive command.
Do you want to proceed? (y/n): y
Your call!
column "product_id" does not exist
LINE 1: DELETE FROM product_orders WHERE product_id =1
^
HINT: Perhaps you meant to reference the column "product_orders.products_id".
Time: 0.009s
nkerns@/tmp:company_database> DELETE FROM product_orders WHERE products_id =1;
You're about to run a destructive command.
Do you want to proceed? (y/n): y
Your call!
DELETE 1
Time: 0.007s
nkerns@/tmp:company_database> select * from product_orders
+------+-------------+---------------+
| id | orders_id | products_id |
|------+-------------+---------------|
| 3 | 2 | 2 |
+------+-------------+---------------+
SELECT 1
Time: 0.014s
nkerns@/tmp:company_database> select orders where products_id =2;
column "orders" does not exist
LINE 1: select orders where products_id =2
^
Time: 0.001s
nkerns@/tmp:company_database> select orders where product_id =2;
column "orders" does not exist
LINE 1: select orders where product_id =2
^
Time: 0.001s
nkerns@/tmp:company_database> select* from orders
+----------------+------+---------------+------------------+
| order_number | id | date_placed | email |
|----------------+------+---------------+------------------|
| 12 | 1 | 2019-12-10 | email@email.com |
| 13 | 2 | 2019-12-11 | email2@email.com |
| 14 | 3 | 2019-12-11 | email3@email.com |
+----------------+------+---------------+------------------+
SELECT 3
Time: 0.015s
nkerns@/tmp:company_database> SELECT orders where id=2
column "orders" does not exist
LINE 1: SELECT orders where id=2
^
Time: 0.001s
nkerns@/tmp:company_database>
[F2] Smart Completion: ON [F3] Multiline: OFF [F4] Emacs-mode
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment