...
Fill the form and press the button to upload your experience
...
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
| Code Block |
|---|
psql postgres |
Step 2: Connect to the specified database before executing the SQL script. (YDIYOI)
| Code Block |
|---|
\c 'database_name' |
Step 3: Execute the SQL file with the ' \i ' command.
| Code Block |
|---|
\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.