![]() ![]() ![]() This opens up another window where there’s an option to write the name of the new database that will be created, as you see in the image below.Ĭlick on the “Create” option and then the “Database” option. In this step, the database has to be created and named before any file can be uploaded into the Postgres database. In the image below, the name of this particular database being imported into Postgres is called NORTHWIND database, so that’s what we’ll name the empty database being created.Īfter saving the file, go to PostgreSQL 13 on the upper left-hand side of the interface and right-click on it. This should open up a drop down menu where you can click on the Refresh option.Īfter clicking on the Refresh option, the Northwind database will appear among the database options like in the image below. Right-clicking on the Northwind database will open up another drop-down menu. Scroll down the options on this menu and click on Restore. This will take you to a window where the format of the file to be imported can be specified along with the file path.Ĭlick on the three dots encircled in red to initiate the file path where the databases have been downloaded on your system. It is important to make sure that the folder for the compressed database files is in the format All Files, as is highlighted in red in the bottom right-hand corner. The black arrow is to highlight the end of the Northwind file path.Īfter that, right-click on the Northwind database, under the Database header at the top left-hand side. To ensure that there are tables in the database, it is important to click on the Northwind database, then Schemas, after which you click on Tables. That will show a list of tables contained within the database. The second approach to loading data into Postgres in this article is with CSV files. To do this, first create another database in Postgres. The database in this article will be called “orders”. ![]() Open up the Query Tool in Postgres and type in the script for the data in your CSV file. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |