![]() As we can see, the database nest_api was created. ![]() My terminal would look like this after we executed all four commands successfully. CREATE DATABASE nest_api creating the database we need.psql postgres open psql CLI with user postgres.$ psql postgres $ CREATE DATABASE nest_api $ \l $ \q If you have PostgreSQL installed, the following four commands will run on Linux, Mac, and Windows machines. Create two new aliases to start and stop. Again, you need to have PostgreSQL installed on your machine. In your command-line run the command: brew install postgres Run the command: ln -sfv /usr/local/opt/postgresql/. PS2: as its tradition and philosophy, we expect orthogonal behaviour in the commands offered by PostgreSQL. Using modern client and connections, v9 . The final line is the psql command prompt, waiting for you to enter a command. The focus in this question is URI standard. Configure the Command Line Interface (CLI). I know, everybody handles that differently, some people use a GUI, but we going to use our terminal. even for postgres user, and all my scrips are using URI connection-string standard, no more -U etc. Let’s get startedįirst, we need to create our PostgreSQL database. I will choose Visual Studio Code as my code editor. RUN /etc/init.d/postgresql start
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |