Just need some help with the initial set up of starting to make a query file using psql.
Currently I have an .sql file which creates a bunch of tables and also fills in the tables with data.
I have this in a directory and I just need help with the command in psql to somehow use this .sql to create the database. There will be another .sql file which I query the database from.
I know what I need to do for the commands to get the data I need, I just need help on where to start on how to use psql to make a database from a .sql that has the table and info for the tables, and then psql to read another .sql to query the database.
Sorry this is my first time working with sql so I apologize if my explanation sounds strange.
edit: some more info is I am trying to do this on my local host and gedit to make the .sql files
Bookmarks