What is the command to run sql file in linux

The command to run a sql file on Linux is "psql -f test.sql". The method for running a sql script on Linux is: 1. Use the shell tool to log in to the server where postgresql is installed; 2. Edit the content of the sql script; 3. . Execute the "test.sql" script through the "psql -f test.sql" command.

#The operating environment of this tutorial: linux5.9.8 system, Dell G3 computer.

What is the command to run sql file on Linux?

The specific steps for running sql scripts on Linux are as follows:

1. Use the shell tool to log in to the server where postgresql is installed, switch to the postgres user, the default operating user of postgresql, the command is :su - postgres, check that the current path is /var/lib/psql, create a test.sql script file, the command is: vim test.sql.

2. The content of the sql script is: create table test (id int not null primary key,name text);insert into test valus(1, 't1');

3. Execute the test.sql script, the command is: psql -f test.sql

This is because postgresql is installed on this machine, in the first step We switched to the postgres user, so the default is the postgres user to operate here, without bringing the user name and password. The execution results are as follows. You can see two prompts:

create table

insert 0 1

After the execution is completed, we log in to the database and the command is: psql

4. After entering the psql interactive command line, we execute two view commands:\d

You can see that the table test has indeed been created successfully, and then execute the command: \d test

You can see that the fields in the table are id and name, which are the same as the content in our creation statement, indicating that the first statement was executed successfully.

5. Check the data in the table. The command is: select * from test;

The displayed value is 1, t1, indicating that the second item is executed. The statement is also executed successfully, indicating that the test.sql script is executed successfully.

6. The default is postgres user. The local operation is, no user and password are required. Now let’s try to operate postgresql on the remote linux server, that is to say, execute A local script file that creates the table on the remote server. As shown in the figure below, the command is: psql -U test1 -h 192.168.1.194 -f test.sql, enter the password of the corresponding user.

7. Log in to this remote server. The command is: psql -U test -h 192.168.194

Execute the view command: \d,\ d test

Finally query the database: select * from test; the results are consistent with the above.

Recommended study: "Linux Video Tutorial"

The above is the detailed content of What is the command to run sql file in linux. For more information, please follow other related articles on the PHP Chinese website!