How to upload data to Supabase using Postgres and Docker скачать в хорошем качестве

How to upload data to Supabase using Postgres and Docker

Supabase is a postgres development platform, with very good options for user authentication, replacement for a backend, automated router documentation, and the framework I'm currently using for the Pokemon Trading Website. In order to submit data to the database, we need to access it using docker. It works to our next tutorial , where we will install all necessary containers to create tables and submit data to our online Postgres database. Install postgres ``` docker pull postgres:17 ``` ``` docker run --mount type=bind,src=C:/Users/Migue/Documents/community_dev/docker,dst=/root/data/projects/pokeTrade --name postgres-db-local -e POSTGRES_PASSWORD=dogsarecool -e POSTGRES_USER=miguel -e POSTGRES_DB=mydatabase -p 5434:5434 -d postgres:17 ``` ``` $env:PGSSLMODE="require" docker exec -it postgres-db-local psql -d postgres -h host -p 5432 -U username ``` host is in connect button on top of supabase website click on method session pooler view parameters copy host and username if you know your database password, then grab it otherwise go to database - settings - reset password, and store it somewhere safe \ - backlash Error ``` At line:1 char:26 $env:PGSSLMODE="require" docker exec -it postgres-db-local psql ` -d ... Unexpected token 'docker' in expression or statement. CategoryInfo : ParserError: (:) [], ParentContainsErrorRecordException FullyQualifiedErrorId : UnexpectedToken ``` Solution - remove $env:PGSSLMODE="require" CREATE TABLE card ( card_idUUID DEFAULT uuid_generate_v4() UNIQUE NOT NULL, card_name text, card_image, card_local_id, ); ALTER TABLE card ENABLE ROW LEVEL SECURITY; make sure you have a cards.csv structured like this inside your directory card_name,card_image,card_local_id name1, image1,id1 name2,image2,id2 \copy set ("official_card_count","total_card_count","set_code","set_name") FROM 'root/data/projects/pokeTrade' WITH (FORMAT CSV, NULL 'NULL', HEADER);