Postgresql: read the content of file and insert in to Column throws 'cat' is not recognized as an internal or external command,

Question

i have 2 files. 1) is txt.sql and 2) is post.html . i am try to insert in to my postgresql Table using .sql script. used windows cmd, Powershell and my IDE(vscode as well).

my script code here txt.sql

\set content `cat post.html`
INSERT INTO posts (
    post_name,
    post_date,
    title,
    body
)
VALUES(
    'hello_world',
    '2021-12-20',
    'Hello World',
    :'content'
);

and my post.html code here

<h1>
    Hello World!
</h1>
<p>
    Thank you for visiting my blog.
</p>

when i ran below command against myapp database.

myapp-# \i txt.sql

got below results and inserted data with out content

'cat' is not recognized as an internal or external command, operable program or batch file. INSERT 0 1

i belive cat shell command only for unix and not for windows. can you help me with other solution to read data from file and insert in to table column in windows psql.

The prompt `myapp-#` suggests that you are on a continuation line. Try again. — Laurenz Albe, Dec 23 '21 at 17:20
yes, but body field value is not inserted. that's the problem. i want to insert value for body field from content of file — sdandamud1, Dec 24 '21 at 14:59
Your sample code works perfectly. The problem is that you are in the middle of a statement. Disconnect from the database, reconnect, and it will work. — Laurenz Albe, Dec 25 '21 at 01:04
tried, but body is not gonna inserted, i think bacuase mine is windows machine? @ Laurenz Albe is any working example? — sdandamud1, Dec 29 '21 at 19:02

score 0 · Answer 1 · answered Sep 13 '22 at 16:19

0

The Windows equivalent of cat is called type.

From the horse's mouth:

type is a built in command which displays the contents of a text file.

answered Sep 13 '22 at 16:19

BigSmoke

406
4
14

Postgresql: read the content of file and insert in to Column throws 'cat' is not recognized as an internal or external command,

1 Answers1