Which of the modern DBMS contain input / output facilities?

Question

Database

Which of the modern DBMS contain, in addition to standard SQL commands, commands, say, for entering data into the database from the outside, from a file or from stdin?

Answer 1

Yes, probably anyone with console commands.
for example, muscle and postgres.

Answer 2

A strange task, but for example Postgresql can import raw data from a file
https://postgrespro.ru/docs/postgrespro/9.5/sql-copy

Answer 3

For example, about MS SQL:
Usually this is taken out as separate tools, such as SQL Server Import Wizard for rather interactive or bcp for batch. Well, there is inside, starting from bulk and ending with Data Transformation Service. And of course sqlcmd is just stdin / stdout / stderr according to the classics.
The rest - know the plus or minus the same and most often out of the box (except that dts is not all)
What is the question?

Answer 4

The database server is treated as a black box. Very similar to an HTTP server. The main task of which is to interact with the request-response protocol in the SQL language. And all the data that you get from it can be obtained like this. There is nowhere to output to the console. no console (usually). And responsible DBAs usually do not let anyone access the SSH console so that there are no problems with security and load. This is how they do it in the enterprise and in enterprises.
But if you installed the database locally for yourself, then you can of course write yourself reports on the local file system. Oracle has the UTL_FILE package. I do not recommend writing to the text console. This output can be blocking and your database performance will drop. it will WAITING for the screen to scroll eg.
An alternative would be to simply use the export utilities exp/expdp/dump/pg_dump etc Or any console clients in general. But perhaps the author's question lies in the plane of debugging stored procedures, for example? Here it is still more complicated and you need to look at the specific DBMS.