Pg_restore: processing data for table "public.address" LINE 1: SELECT pg_tval('actor_actor_id_seq', 200, true) Ĭommand was: SELECT pg_tval('actor_actor_id_seq', 200, true) Pg_restore: could not execute query: ERROR: relation "actor_actor_id_seq" does not exist Pg_restore: Error from TOC entry 2643 0 0 SEQUENCE SET actor_actor_id_seq postgres Pg_restore: executing SEQUENCE SET actor_actor_id_seq Pg_restore: could not execute query: ERROR: relation "actor" does not existĬommand was: COPY actor (actor_id, first_name, last_name, last_update) FROM stdin Pg_restore: Error from TOC entry 2610 0 16430 TABLE DATA actor postgres Pg_restore: processing data for table "public.actor" Pg_restore: connecting to database for restore Here's the full error, I have no idea what any of it means, as I'm brand new to SQL and just setting it up: /Library/PostgreSQL/10/bin/pg_restore -host "localhost" -port "5432" -username "postgres" -no-password -dbname "dvdrental" -section=data -verbose "/Users/chasehippen/Downloads/Postgresql/dvdrental.tar" I also just verified that other tar files and a sql file aren't working. I've also completely rebooted the computer several times since then. I just tried doing it on a fresh install in a Windows environment and I get the exact same error. I also tried reinstalling pgAdmin and fully reinstalling postgresql including removing the user account. I've tried deleting and re-adding the database twice and I still get the same error.
#Import csv in pgadmin 4 mac osx
I'm on Mac OSX and the pgAmin instance is being loaded in Chrome if that helps. I have a file dvdrental.tar, I create a new database dvdrental > right click > Restore > Select File > Pick "Data" under Restore options, and I get the error below.
![import csv in pgadmin 4 import csv in pgadmin 4](https://bucketeer-e05bbc84-baa3-437e-9518-adb32be77984.s3.amazonaws.com/public/images/d93e34cb-5b47-4af9-abd1-cdd5b94d5428_940x788.png)
I'm taking an intro to SQL course and I can't get my very first database loaded.