Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- prabh_leen@DESKTOP-UFGI5TE:~$ psql -h localhost -U postgres bookbrainz -c "SELECT name FROM bookbrainz.editor"
- Password for user postgres:
- ERROR: relation "bookbrainz.editor" does not exist
- LINE 1: SELECT name FROM bookbrainz.editor
- ^
- prabh_leen@DESKTOP-UFGI5TE:~$ psql -h localhost -U postgres --command="DROP SCHEMA bookbrainz CASCADE"
- Password for user postgres:
- NOTICE: drop cascades to 69 other objects
- DETAIL: drop cascades to type bookbrainz.entity_type
- drop cascades to type bookbrainz.lang_proficiency
- drop cascades to function bookbrainz.process_author()
- drop cascades to function bookbrainz.process_edition()
- drop cascades to function bookbrainz.process_edition_group()
- drop cascades to function bookbrainz.process_publisher()
- drop cascades to function bookbrainz.process_work()
- drop cascades to sequence bookbrainz._editor_entity_visits_id_seq
- drop cascades to sequence bookbrainz._editor_entity_visits_id_seq1
- drop cascades to table bookbrainz.achievement_type
- drop cascades to table bookbrainz.achievement_unlock
- drop cascades to table bookbrainz.alias
- drop cascades to table bookbrainz.alias_set
- drop cascades to table bookbrainz.alias_set__alias
- drop cascades to table bookbrainz.annotation
- drop cascades to table bookbrainz.author_data
- drop cascades to table bookbrainz.author_header
- drop cascades to table bookbrainz.author_revision
- drop cascades to table bookbrainz.entity
- drop cascades to view bookbrainz.author
- drop cascades to table bookbrainz.author_credit
- drop cascades to table bookbrainz.author_credit_name
- drop cascades to table bookbrainz.author_type
- drop cascades to table bookbrainz.disambiguation
- drop cascades to table bookbrainz.edition_data
- drop cascades to table bookbrainz.edition_header
- drop cascades to table bookbrainz.edition_revision
- drop cascades to view bookbrainz.edition
- drop cascades to table bookbrainz.edition_format
- drop cascades to table bookbrainz.edition_group_data
- drop cascades to table bookbrainz.edition_group_header
- drop cascades to table bookbrainz.edition_group_revision
- drop cascades to view bookbrainz.edition_group
- drop cascades to table bookbrainz.edition_group_type
- drop cascades to table bookbrainz.edition_status
- drop cascades to table bookbrainz.editor
- drop cascades to table bookbrainz.editor__language
- drop cascades to table bookbrainz.editor_type
- drop cascades to table bookbrainz.entity_redirect
- drop cascades to table bookbrainz.identifier
- drop cascades to table bookbrainz.identifier_set
- drop cascades to table bookbrainz.identifier_set__identifier
- drop cascades to table bookbrainz.identifier_type
- drop cascades to table bookbrainz.language_set
- drop cascades to table bookbrainz.language_set__language
- drop cascades to table bookbrainz.note
- drop cascades to table bookbrainz.publisher_data
- drop cascades to table bookbrainz.publisher_header
- drop cascades to table bookbrainz.publisher_revision
- drop cascades to view bookbrainz.publisher
- drop cascades to table bookbrainz.publisher_set
- drop cascades to table bookbrainz.publisher_set__publisher
- drop cascades to table bookbrainz.publisher_type
- drop cascades to table bookbrainz.relationship
- drop cascades to table bookbrainz.relationship_set
- drop cascades to table bookbrainz.relationship_set__relationship
- drop cascades to table bookbrainz.relationship_type
- drop cascades to table bookbrainz.release_event
- drop cascades to table bookbrainz.release_event_set
- drop cascades to table bookbrainz.release_event_set__release_event
- drop cascades to table bookbrainz.revision
- drop cascades to table bookbrainz.revision_parent
- drop cascades to table bookbrainz.title_type
- drop cascades to table bookbrainz.title_unlock
- drop cascades to table bookbrainz.work_data
- drop cascades to table bookbrainz.work_header
- drop cascades to table bookbrainz.work_revision
- drop cascades to view bookbrainz.work
- drop cascades to table bookbrainz.work_type
- DROP SCHEMA
- prabh_leen@DESKTOP-UFGI5TE:~$ psql -h localhost -U postgres --command="DROP SCHEMA musicbrainz CASCADE"
- Password for user postgres:
- NOTICE: drop cascades to 6 other objects
- DETAIL: drop cascades to table musicbrainz.area
- drop cascades to table musicbrainz.area_type
- drop cascades to table musicbrainz.country_area
- drop cascades to table musicbrainz.gender
- drop cascades to table musicbrainz.language
- drop cascades to table musicbrainz.replication_control
- DROP SCHEMA
- prabh_leen@DESKTOP-UFGI5TE:~$ psql -h localhost -U postgres -f latest.sql
- Password for user postgres:
- SET
- SET
- SET
- SET
- set_config
- ------------
- (1 row)
- SET
- SET
- SET
- CREATE SCHEMA
- ALTER SCHEMA
- CREATE SCHEMA
- ALTER SCHEMA
- CREATE EXTENSION
- COMMENT
- CREATE EXTENSION
- COMMENT
- CREATE TYPE
- ALTER TYPE
- CREATE TYPE
- ALTER TYPE
- CREATE FUNCTION
- ALTER FUNCTION
- CREATE FUNCTION
- ALTER FUNCTION
- CREATE FUNCTION
- ALTER FUNCTION
- CREATE FUNCTION
- ALTER FUNCTION
- CREATE FUNCTION
- ALTER FUNCTION
- CREATE SEQUENCE
- ALTER TABLE
- CREATE SEQUENCE
- ALTER TABLE
- SET
- SET
- CREATE TABLE
- ALTER TABLE
- CREATE SEQUENCE
- ALTER TABLE
- ALTER SEQUENCE
- CREATE TABLE
- ALTER TABLE
- CREATE SEQUENCE
- ALTER TABLE
- ALTER SEQUENCE
- CREATE TABLE
- ALTER TABLE
- CREATE SEQUENCE
- ALTER TABLE
- ALTER SEQUENCE
- CREATE TABLE
- ALTER TABLE
- CREATE TABLE
- ALTER TABLE
- CREATE SEQUENCE
- ALTER TABLE
- ALTER SEQUENCE
- CREATE TABLE
- ALTER TABLE
- CREATE SEQUENCE
- ALTER TABLE
- ALTER SEQUENCE
- CREATE TABLE
- ALTER TABLE
- CREATE TABLE
- ALTER TABLE
- CREATE TABLE
- ALTER TABLE
- CREATE TABLE
- ALTER TABLE
- CREATE VIEW
- ALTER TABLE
- CREATE TABLE
- ALTER TABLE
- CREATE TABLE
- ALTER TABLE
- CREATE TABLE
- ALTER TABLE
- CREATE SEQUENCE
- ALTER TABLE
- ALTER SEQUENCE
- CREATE SEQUENCE
- ALTER TABLE
- ALTER SEQUENCE
- CREATE SEQUENCE
- ALTER TABLE
- ALTER SEQUENCE
- CREATE TABLE
- ALTER TABLE
- CREATE SEQUENCE
- ALTER TABLE
- ALTER SEQUENCE
- CREATE TABLE
- ALTER TABLE
- CREATE TABLE
- ALTER TABLE
- CREATE TABLE
- ALTER TABLE
- CREATE VIEW
- ALTER TABLE
- CREATE SEQUENCE
- ALTER TABLE
- ALTER SEQUENCE
- CREATE TABLE
- ALTER TABLE
- CREATE SEQUENCE
- ALTER TABLE
- ALTER SEQUENCE
- CREATE TABLE
- ALTER TABLE
- CREATE TABLE
- ALTER TABLE
- CREATE TABLE
- ALTER TABLE
- CREATE VIEW
- ALTER TABLE
- CREATE TABLE
- ALTER TABLE
- CREATE TABLE
- ALTER TABLE
- CREATE SEQUENCE
- ALTER TABLE
- ALTER SEQUENCE
- CREATE TABLE
- ALTER TABLE
- CREATE TABLE
- ALTER TABLE
- CREATE SEQUENCE
- ALTER TABLE
- ALTER SEQUENCE
- CREATE TABLE
- ALTER TABLE
- CREATE SEQUENCE
- ALTER TABLE
- ALTER SEQUENCE
- CREATE TABLE
- ALTER TABLE
- CREATE TABLE
- ALTER TABLE
- CREATE SEQUENCE
- ALTER TABLE
- ALTER SEQUENCE
- CREATE TABLE
- ALTER TABLE
- CREATE TABLE
- ALTER TABLE
- CREATE SEQUENCE
- ALTER TABLE
- ALTER SEQUENCE
- CREATE TABLE
- ALTER TABLE
- CREATE SEQUENCE
- ALTER TABLE
- ALTER SEQUENCE
- CREATE TABLE
- ALTER TABLE
- CREATE TABLE
- ALTER TABLE
- CREATE SEQUENCE
- ALTER TABLE
- ALTER SEQUENCE
- CREATE TABLE
- ALTER TABLE
- CREATE SEQUENCE
- ALTER TABLE
- ALTER SEQUENCE
- CREATE SEQUENCE
- ALTER TABLE
- ALTER SEQUENCE
- CREATE SEQUENCE
- ALTER TABLE
- ALTER SEQUENCE
- CREATE TABLE
- ALTER TABLE
- CREATE TABLE
- ALTER TABLE
- CREATE TABLE
- ALTER TABLE
- CREATE VIEW
- ALTER TABLE
- CREATE SEQUENCE
- ALTER TABLE
- ALTER SEQUENCE
- CREATE TABLE
- ALTER TABLE
- CREATE TABLE
- ALTER TABLE
- CREATE SEQUENCE
- ALTER TABLE
- ALTER SEQUENCE
- CREATE TABLE
- ALTER TABLE
- CREATE SEQUENCE
- ALTER TABLE
- ALTER SEQUENCE
- CREATE TABLE
- ALTER TABLE
- CREATE SEQUENCE
- ALTER TABLE
- ALTER SEQUENCE
- CREATE TABLE
- ALTER TABLE
- CREATE TABLE
- ALTER TABLE
- CREATE SEQUENCE
- ALTER TABLE
- ALTER SEQUENCE
- CREATE TABLE
- ALTER TABLE
- CREATE SEQUENCE
- ALTER TABLE
- ALTER SEQUENCE
- CREATE TABLE
- ALTER TABLE
- CREATE SEQUENCE
- ALTER TABLE
- ALTER SEQUENCE
- CREATE TABLE
- ALTER TABLE
- CREATE TABLE
- ALTER TABLE
- CREATE SEQUENCE
- ALTER TABLE
- ALTER SEQUENCE
- CREATE TABLE
- ALTER TABLE
- CREATE SEQUENCE
- ALTER TABLE
- ALTER SEQUENCE
- CREATE TABLE
- ALTER TABLE
- CREATE TABLE
- ALTER TABLE
- CREATE SEQUENCE
- ALTER TABLE
- ALTER SEQUENCE
- CREATE TABLE
- ALTER TABLE
- CREATE SEQUENCE
- ALTER TABLE
- ALTER SEQUENCE
- CREATE TABLE
- ALTER TABLE
- CREATE TABLE
- ALTER TABLE
- CREATE TABLE
- ALTER TABLE
- CREATE VIEW
- ALTER TABLE
- CREATE SEQUENCE
- ALTER TABLE
- ALTER SEQUENCE
- CREATE TABLE
- ALTER TABLE
- CREATE SEQUENCE
- ALTER TABLE
- ALTER SEQUENCE
- CREATE TABLE
- ALTER TABLE
- CREATE SEQUENCE
- ALTER TABLE
- ALTER SEQUENCE
- CREATE TABLE
- ALTER TABLE
- CREATE SEQUENCE
- ALTER TABLE
- ALTER SEQUENCE
- CREATE TABLE
- ALTER TABLE
- CREATE TABLE
- ALTER TABLE
- CREATE SEQUENCE
- ALTER TABLE
- ALTER SEQUENCE
- CREATE TABLE
- ALTER TABLE
- CREATE SEQUENCE
- ALTER TABLE
- ALTER SEQUENCE
- CREATE TABLE
- ALTER TABLE
- CREATE SEQUENCE
- ALTER TABLE
- ALTER SEQUENCE
- ALTER TABLE
- ALTER TABLE
- ALTER TABLE
- ALTER TABLE
- ALTER TABLE
- ALTER TABLE
- ALTER TABLE
- ALTER TABLE
- ALTER TABLE
- ALTER TABLE
- ALTER TABLE
- ALTER TABLE
- ALTER TABLE
- ALTER TABLE
- ALTER TABLE
- ALTER TABLE
- ALTER TABLE
- ALTER TABLE
- ALTER TABLE
- ALTER TABLE
- ALTER TABLE
- ALTER TABLE
- ALTER TABLE
- ALTER TABLE
- ALTER TABLE
- ALTER TABLE
- ALTER TABLE
- ALTER TABLE
- ALTER TABLE
- ALTER TABLE
- ALTER TABLE
- ALTER TABLE
- ALTER TABLE
- ALTER TABLE
- ALTER TABLE
- ALTER TABLE
- ALTER TABLE
- ALTER TABLE
- ALTER TABLE
- setval
- --------
- 186
- (1 row)
- setval
- --------
- 16311
- (1 row)
- COPY 27
- setval
- --------
- 27
- (1 row)
- COPY 2464
- setval
- --------
- 2467
- (1 row)
- COPY 9642
- setval
- --------
- 10266
- (1 row)
- COPY 8620
- COPY 10024
- setval
- --------
- 8969
- (1 row)
- COPY 161
- setval
- --------
- 162
- (1 row)
- COPY 0
- COPY 0
- COPY 4426
- COPY 1779
- COPY 4569
- COPY 2
- setval
- --------
- 1
- (1 row)
- setval
- --------
- 4428
- (1 row)
- setval
- --------
- 2
- (1 row)
- COPY 670
- setval
- --------
- 687
- (1 row)
- COPY 2616
- setval
- --------
- 2658
- (1 row)
- COPY 5
- setval
- --------
- 5
- (1 row)
- COPY 1741
- COPY 1067
- COPY 1799
- COPY 5
- COPY 1269
- COPY 2712
- COPY 2
- setval
- --------
- 2
- (1 row)
- COPY 1368
- COPY 0
- setval
- --------
- 1654
- (1 row)
- COPY 2
- setval
- --------
- 2
- (1 row)
- COPY 6748
- COPY 0
- COPY 5600
- setval
- --------
- 5753
- (1 row)
- COPY 3470
- COPY 6473
- setval
- --------
- 3505
- (1 row)
- COPY 27
- setval
- --------
- 17
- (1 row)
- COPY 4762
- COPY 5038
- setval
- --------
- 4946
- (1 row)
- COPY 6984
- setval
- --------
- 7333
- (1 row)
- setval
- --------
- 1757
- (1 row)
- setval
- --------
- 5
- (1 row)
- COPY 754
- setval
- --------
- 754
- (1 row)
- COPY 450
- COPY 768
- COPY 1295
- COPY 1295
- setval
- --------
- 1479
- (1 row)
- COPY 3
- setval
- --------
- 2
- (1 row)
- COPY 4572
- setval
- --------
- 4997
- (1 row)
- COPY 5067
- COPY 16740
- setval
- --------
- 5964
- (1 row)
- COPY 57
- setval
- --------
- 56
- (1 row)
- COPY 1980
- setval
- --------
- 1988
- (1 row)
- COPY 1980
- COPY 1980
- setval
- --------
- 2173
- (1 row)
- COPY 11604
- setval
- --------
- 12494
- (1 row)
- COPY 7251
- COPY 12
- setval
- --------
- 12
- (1 row)
- COPY 228
- setval
- --------
- 228
- (1 row)
- COPY 4556
- setval
- --------
- 4607
- (1 row)
- COPY 2183
- COPY 4647
- COPY 12
- setval
- --------
- 10
- (1 row)
- COPY 115515
- setval
- --------
- 1
- (1 row)
- COPY 7
- setval
- --------
- 1
- (1 row)
- COPY 257
- COPY 3
- setval
- --------
- 1
- (1 row)
- COPY 7843
- setval
- --------
- 1
- (1 row)
- COPY 1
- setval
- --------
- 1
- (1 row)
- ALTER TABLE
- ALTER TABLE
- ALTER TABLE
- ALTER TABLE
- ALTER TABLE
- ALTER TABLE
- ALTER TABLE
- ALTER TABLE
- ALTER TABLE
- ALTER TABLE
- ALTER TABLE
- ALTER TABLE
- ALTER TABLE
- ALTER TABLE
- ALTER TABLE
- ALTER TABLE
- ALTER TABLE
- ALTER TABLE
- ALTER TABLE
- ALTER TABLE
- ALTER TABLE
- ALTER TABLE
- ALTER TABLE
- ALTER TABLE
- ALTER TABLE
- ALTER TABLE
- ALTER TABLE
- ALTER TABLE
- ALTER TABLE
- ALTER TABLE
- ALTER TABLE
- ALTER TABLE
- ALTER TABLE
- ALTER TABLE
- ALTER TABLE
- ALTER TABLE
- ALTER TABLE
- ALTER TABLE
- ALTER TABLE
- ALTER TABLE
- ALTER TABLE
- ALTER TABLE
- ALTER TABLE
- ALTER TABLE
- ALTER TABLE
- ALTER TABLE
- ALTER TABLE
- ALTER TABLE
- ALTER TABLE
- ALTER TABLE
- ALTER TABLE
- ALTER TABLE
- ALTER TABLE
- ALTER TABLE
- ALTER TABLE
- ALTER TABLE
- ALTER TABLE
- ALTER TABLE
- ALTER TABLE
- ALTER TABLE
- ALTER TABLE
- ALTER TABLE
- ALTER TABLE
- ALTER TABLE
- ALTER TABLE
- ALTER TABLE
- ALTER TABLE
- CREATE TRIGGER
- CREATE TRIGGER
- CREATE TRIGGER
- CREATE TRIGGER
- CREATE TRIGGER
- ALTER TABLE
- ALTER TABLE
- ALTER TABLE
- ALTER TABLE
- ALTER TABLE
- ALTER TABLE
- ALTER TABLE
- ALTER TABLE
- ALTER TABLE
- ALTER TABLE
- ALTER TABLE
- ALTER TABLE
- ALTER TABLE
- ALTER TABLE
- ALTER TABLE
- ALTER TABLE
- ALTER TABLE
- ALTER TABLE
- ALTER TABLE
- ALTER TABLE
- ALTER TABLE
- ALTER TABLE
- ALTER TABLE
- ALTER TABLE
- ALTER TABLE
- ALTER TABLE
- ALTER TABLE
- ALTER TABLE
- ALTER TABLE
- ALTER TABLE
- ALTER TABLE
- ALTER TABLE
- ALTER TABLE
- ALTER TABLE
- ALTER TABLE
- ALTER TABLE
- ALTER TABLE
- ALTER TABLE
- ALTER TABLE
- ALTER TABLE
- ALTER TABLE
- ALTER TABLE
- ALTER TABLE
- ALTER TABLE
- ALTER TABLE
- ALTER TABLE
- ALTER TABLE
- ALTER TABLE
- ALTER TABLE
- ALTER TABLE
- ALTER TABLE
- ALTER TABLE
- ALTER TABLE
- ALTER TABLE
- ALTER TABLE
- ALTER TABLE
- ALTER TABLE
- ALTER TABLE
- ALTER TABLE
- ALTER TABLE
- ALTER TABLE
- ALTER TABLE
- ALTER TABLE
- ALTER TABLE
- ALTER TABLE
- ALTER TABLE
- ALTER TABLE
- ALTER TABLE
- ALTER TABLE
- ALTER TABLE
- ALTER TABLE
- ALTER TABLE
- ALTER TABLE
- ALTER TABLE
- ALTER TABLE
- ALTER TABLE
- ALTER TABLE
- ALTER TABLE
- ALTER TABLE
- ALTER TABLE
- ALTER TABLE
- ALTER TABLE
- ALTER TABLE
- ALTER TABLE
- ALTER TABLE
- ALTER TABLE
- ALTER TABLE
- ALTER TABLE
- ALTER TABLE
- ALTER TABLE
- ALTER TABLE
- ALTER TABLE
- ALTER TABLE
- ALTER TABLE
- ALTER TABLE
- ALTER TABLE
- ALTER TABLE
- ALTER TABLE
- ALTER TABLE
- ALTER TABLE
- ALTER TABLE
- ALTER TABLE
- ALTER TABLE
- ALTER TABLE
- ALTER TABLE
- ALTER TABLE
- ALTER TABLE
- ALTER TABLE
- REVOKE
- REVOKE
- GRANT
- GRANT
- prabh_leen@DESKTOP-UFGI5TE:~$ psql -h localhost -U postgres bookbrainz -c "SELECT name FROM bookbrainz.editor"
- Password for user postgres:
- ERROR: relation "bookbrainz.editor" does not exist
- LINE 1: SELECT name FROM bookbrainz.editor
- ^
Add Comment
Please, Sign In to add comment