Build-a-periodic-table-database

Backend Development
1

here is the link:https://www.freecodecamp.org/learn/relational-database/build-a-periodic-table-database-project/build-a-periodic-table-database
keep’s getting the error:_
psql: warning: extra command-line argument “SELECT name FROM elements WHERE atomic_number = 1” ignored
psql: warning: extra command-line argument “SELECT symbol FROM elements WHERE atomic_number = 1” ignored
psql: warning: extra command-line argument “SELECT atomic_mass FROM properties WHERE atomic_number = 1” ignored
psql: warning: extra command-line argument “SELECT melting_point_celsius FROM properties WHERE atomic_number = 1” ignored
psql: warning: extra command-line argument “SELECT boiling_point_celsius FROM properties WHERE atomic_number = 1” ignored
psql: warning: extra command-line argument “SELECT type FROM properties full join types using(type_id) WHERE atomic_number = 1” ignored
The element with atomic number 1 is (). It’s a , with a mass of amu. has a melting point of celsius and a boiling point of celsius.

2

We can’t see your code so you have to save a dump of your database into a periodic_table.sql file, as well as your element.sh file and then share them here.

3

here is the link for the public repository:-

4

thanks for all,i understand and fixed the problem :sweat_smile:
the reason was the flags were not positioned correctly , the correct way was:-
PSQL=“psql -X --username=freecodecamp --dbname=periodic_table --no-align --tuples-only -c”

1 Like