Upload new QR codes into DataBase
In this case we are going to connect to the Database and run a AQL file using ‘psql’.
Before doing the following steps, please upload the SQL file into the 'db_scripts' directory.
Step 1: Connect to PostgreSQL
psql postgres
Step 2: Connect to the specified database before executing the SQL script. (YDIYOI)
\c 'database_name'
Step 3: Execute the SQL file with the ' \i ' command.
\i \path\TO\file_name.sql
NOTE: If no path is specified, then PSQL will use the directory that was last accessed before connecting to PostgreSQL in order to execute the SQL file.Caso de uso escaneo de QR
Diagrama entidad-relacion
