Run an sql file in postgres

It stores SQL statements for creating or modifying database structures, insertions, updates, deletions, or other SQL operations. What is the file extension for SQL database? See wikipedia. A database may also use secondary database file, which normally uses a. How do I start SQL from command line? At the command prompt, type sqlcmd. To end the sqlcmd session, type EXIT at the sqlcmd prompt.

How do I open a. Open the. Select all the content by pressing Ctrl Cmd A. Copy the content by pressing Ctrl Cmd C. How do I run a. Thanks this was a great answer, especially like the "generic form" — JZ. I did some looking round and I couldn't find anyway to do it without copying the file into the docker container, if anyone finds a way please post the answer — Max Carroll.

MaxCarroll, you can mount your file into the container, rather than explicitely copying it, using the volume flag: docker run -v.

You can run a sql command file against a running postgres container via the one liner cat. James Conkling James Conkling 2, 1 1 gold badge 19 19 silver badges 36 36 bronze badges. This worked for me. I was hesitant to use the other answers since they all use multiple lines or would store the file on the docker instance. I think this is the best answer for my use case since it just executes the script and nothing else.

Based on this answer I expected this to work as well, and it did. Seems to work only when psql is run on the db in the docker container. Won't run on a "remote" db. Mentioned this because I only want to use the psql command of the docker container to run an SQL on another db. It helped. This is arguably the most critical of all the options. The final step in this process is to execute the file using the psql command while connecting with an username, host and database.

Note that this example uses the objectrocket role. The following command can be used to access the test. The -a option, also referred to as the --echo-all option, is used to echo, or print, all of the input lines that contain any content.

The following is an example of the --echo-all option:. We hate spam and make it easy to unsubscribe. Collectives on Stack Overflow. Learn more. Asked 11 years, 6 months ago. Active 1 year, 4 months ago. Viewed 58k times. How do I do this. The file is about 1. Improve this question. David David Add a comment. Active Oldest Votes.

Improve this answer.