Why is “<” input redirect not implemented in PowerShell?
Why is input redirection not implemented in PowerShell?
To do something like this:
mysql -u root < create.sql
I had to switch to "cmd.exe".
Is there an alternative way of doing this in PowerShell?
Please note that the output redirection ">" is implemented in PowerShell. Please consider this before giving an answer.
powershell
add a comment |
Why is input redirection not implemented in PowerShell?
To do something like this:
mysql -u root < create.sql
I had to switch to "cmd.exe".
Is there an alternative way of doing this in PowerShell?
Please note that the output redirection ">" is implemented in PowerShell. Please consider this before giving an answer.
powershell
2
Since you gave piping a script tomysql
as your example, I thought I should point you to this in case you try to use Powershell to pipe a backup.
– Joel B Fant
Jul 20 '11 at 14:34
That is exactly what I was looking for. Granted, not the best solution, but a nice hack, without having to switch back to dos-prompt.
– drozzy
Jul 20 '11 at 19:19
A year and a half later, I still don't have an answer to this specific question of why input redirect was not implemented.
– Joel B Fant
Feb 14 '13 at 4:08
add a comment |
Why is input redirection not implemented in PowerShell?
To do something like this:
mysql -u root < create.sql
I had to switch to "cmd.exe".
Is there an alternative way of doing this in PowerShell?
Please note that the output redirection ">" is implemented in PowerShell. Please consider this before giving an answer.
powershell
Why is input redirection not implemented in PowerShell?
To do something like this:
mysql -u root < create.sql
I had to switch to "cmd.exe".
Is there an alternative way of doing this in PowerShell?
Please note that the output redirection ">" is implemented in PowerShell. Please consider this before giving an answer.
powershell
powershell
edited Oct 16 '17 at 21:09
Peter Mortensen
13.6k1986111
13.6k1986111
asked Jul 20 '11 at 13:53
drozzydrozzy
21.6k38135235
21.6k38135235
2
Since you gave piping a script tomysql
as your example, I thought I should point you to this in case you try to use Powershell to pipe a backup.
– Joel B Fant
Jul 20 '11 at 14:34
That is exactly what I was looking for. Granted, not the best solution, but a nice hack, without having to switch back to dos-prompt.
– drozzy
Jul 20 '11 at 19:19
A year and a half later, I still don't have an answer to this specific question of why input redirect was not implemented.
– Joel B Fant
Feb 14 '13 at 4:08
add a comment |
2
Since you gave piping a script tomysql
as your example, I thought I should point you to this in case you try to use Powershell to pipe a backup.
– Joel B Fant
Jul 20 '11 at 14:34
That is exactly what I was looking for. Granted, not the best solution, but a nice hack, without having to switch back to dos-prompt.
– drozzy
Jul 20 '11 at 19:19
A year and a half later, I still don't have an answer to this specific question of why input redirect was not implemented.
– Joel B Fant
Feb 14 '13 at 4:08
2
2
Since you gave piping a script to
mysql
as your example, I thought I should point you to this in case you try to use Powershell to pipe a backup.– Joel B Fant
Jul 20 '11 at 14:34
Since you gave piping a script to
mysql
as your example, I thought I should point you to this in case you try to use Powershell to pipe a backup.– Joel B Fant
Jul 20 '11 at 14:34
That is exactly what I was looking for. Granted, not the best solution, but a nice hack, without having to switch back to dos-prompt.
– drozzy
Jul 20 '11 at 19:19
That is exactly what I was looking for. Granted, not the best solution, but a nice hack, without having to switch back to dos-prompt.
– drozzy
Jul 20 '11 at 19:19
A year and a half later, I still don't have an answer to this specific question of why input redirect was not implemented.
– Joel B Fant
Feb 14 '13 at 4:08
A year and a half later, I still don't have an answer to this specific question of why input redirect was not implemented.
– Joel B Fant
Feb 14 '13 at 4:08
add a comment |
2 Answers
2
active
oldest
votes
Although I'm not entirely sure that this question belongs on Stack Overflow, have you looked at the PS Cmdlet for Get-Content? Look how it's used in the examples on TechNet in Using the Get-Content Cmdlet.
Example:
Get-Content c:scriptstest.txt | Foreach-Object Get-Wmiobject -computername $_ win32_bios
Update: Above link to TechNet is broken, but mentioned in comment by Chad Miller Scripting Guy's post Working Around Legacy Redirection Issues with PowerShell gives three options: -use CMD /c
, Echo
, and Get-Content.
2
That looks backwards :-(
– drozzy
Jul 20 '11 at 14:11
7
Redirection was covered in a Scripting Guys post using Get-Content blogs.technet.com/b/heyscriptingguy/archive/2011/07/16/…
– Chad Miller
Jul 20 '11 at 15:11
2
@Chad Miller, Oh, of course - that would be the obvious place for a user of powershell to look! /end-sarcasm. Thanks.
– drozzy
Jul 20 '11 at 19:16
ss64.com is also an obvious place to look period; though granted, the answer at ss64.com/ps/syntax-redirection.html is only implicit
– nik.shornikov
Apr 29 '15 at 18:51
1
The TechNet worked fine when I tried it.
– Peter Mortensen
Oct 16 '17 at 21:14
add a comment |
I don't think MySQL will accept PowerShell objects piped to it - as Stephan says though, you could use Get-Content and pipe it to the next command.
Check out Stack Overflow question Is PowerShell ready to replace my Cygwin shell on Windows? for reasons on why they haven't copied Unix shells.
Sorry, but where are there reasons? It's just comparisons it seems...
– drozzy
Jul 20 '11 at 19:17
Did you read Jeffery Snover's comment? He talks about the reasons.
– Matt
Jul 20 '11 at 20:07
I see no reasons on input redirects in particular, and I am really not interested in Unix vs Windows tools. I was only curious about the one particular tool. After all, the output redirection ">" is implemented!
– drozzy
Jul 22 '11 at 16:59
I was considering the question more generically in why certain aspects of powershell do not implement the same functions as other shells. I didn't say it answered why < wasn't implemented though it provides insight into the design process,
– Matt
Jul 24 '11 at 10:50
add a comment |
Your Answer
StackExchange.ifUsing("editor", function ()
StackExchange.using("externalEditor", function ()
StackExchange.using("snippets", function ()
StackExchange.snippets.init();
);
);
, "code-snippets");
StackExchange.ready(function()
var channelOptions =
tags: "".split(" "),
id: "1"
;
initTagRenderer("".split(" "), "".split(" "), channelOptions);
StackExchange.using("externalEditor", function()
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled)
StackExchange.using("snippets", function()
createEditor();
);
else
createEditor();
);
function createEditor()
StackExchange.prepareEditor(
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader:
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
,
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
);
);
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f6763086%2fwhy-is-input-redirect-not-implemented-in-powershell%23new-answer', 'question_page');
);
Post as a guest
Required, but never shown
2 Answers
2
active
oldest
votes
2 Answers
2
active
oldest
votes
active
oldest
votes
active
oldest
votes
Although I'm not entirely sure that this question belongs on Stack Overflow, have you looked at the PS Cmdlet for Get-Content? Look how it's used in the examples on TechNet in Using the Get-Content Cmdlet.
Example:
Get-Content c:scriptstest.txt | Foreach-Object Get-Wmiobject -computername $_ win32_bios
Update: Above link to TechNet is broken, but mentioned in comment by Chad Miller Scripting Guy's post Working Around Legacy Redirection Issues with PowerShell gives three options: -use CMD /c
, Echo
, and Get-Content.
2
That looks backwards :-(
– drozzy
Jul 20 '11 at 14:11
7
Redirection was covered in a Scripting Guys post using Get-Content blogs.technet.com/b/heyscriptingguy/archive/2011/07/16/…
– Chad Miller
Jul 20 '11 at 15:11
2
@Chad Miller, Oh, of course - that would be the obvious place for a user of powershell to look! /end-sarcasm. Thanks.
– drozzy
Jul 20 '11 at 19:16
ss64.com is also an obvious place to look period; though granted, the answer at ss64.com/ps/syntax-redirection.html is only implicit
– nik.shornikov
Apr 29 '15 at 18:51
1
The TechNet worked fine when I tried it.
– Peter Mortensen
Oct 16 '17 at 21:14
add a comment |
Although I'm not entirely sure that this question belongs on Stack Overflow, have you looked at the PS Cmdlet for Get-Content? Look how it's used in the examples on TechNet in Using the Get-Content Cmdlet.
Example:
Get-Content c:scriptstest.txt | Foreach-Object Get-Wmiobject -computername $_ win32_bios
Update: Above link to TechNet is broken, but mentioned in comment by Chad Miller Scripting Guy's post Working Around Legacy Redirection Issues with PowerShell gives three options: -use CMD /c
, Echo
, and Get-Content.
2
That looks backwards :-(
– drozzy
Jul 20 '11 at 14:11
7
Redirection was covered in a Scripting Guys post using Get-Content blogs.technet.com/b/heyscriptingguy/archive/2011/07/16/…
– Chad Miller
Jul 20 '11 at 15:11
2
@Chad Miller, Oh, of course - that would be the obvious place for a user of powershell to look! /end-sarcasm. Thanks.
– drozzy
Jul 20 '11 at 19:16
ss64.com is also an obvious place to look period; though granted, the answer at ss64.com/ps/syntax-redirection.html is only implicit
– nik.shornikov
Apr 29 '15 at 18:51
1
The TechNet worked fine when I tried it.
– Peter Mortensen
Oct 16 '17 at 21:14
add a comment |
Although I'm not entirely sure that this question belongs on Stack Overflow, have you looked at the PS Cmdlet for Get-Content? Look how it's used in the examples on TechNet in Using the Get-Content Cmdlet.
Example:
Get-Content c:scriptstest.txt | Foreach-Object Get-Wmiobject -computername $_ win32_bios
Update: Above link to TechNet is broken, but mentioned in comment by Chad Miller Scripting Guy's post Working Around Legacy Redirection Issues with PowerShell gives three options: -use CMD /c
, Echo
, and Get-Content.
Although I'm not entirely sure that this question belongs on Stack Overflow, have you looked at the PS Cmdlet for Get-Content? Look how it's used in the examples on TechNet in Using the Get-Content Cmdlet.
Example:
Get-Content c:scriptstest.txt | Foreach-Object Get-Wmiobject -computername $_ win32_bios
Update: Above link to TechNet is broken, but mentioned in comment by Chad Miller Scripting Guy's post Working Around Legacy Redirection Issues with PowerShell gives three options: -use CMD /c
, Echo
, and Get-Content.
edited Oct 16 '17 at 21:12
Peter Mortensen
13.6k1986111
13.6k1986111
answered Jul 20 '11 at 13:57
Stephen KininghamStephen Kiningham
444617
444617
2
That looks backwards :-(
– drozzy
Jul 20 '11 at 14:11
7
Redirection was covered in a Scripting Guys post using Get-Content blogs.technet.com/b/heyscriptingguy/archive/2011/07/16/…
– Chad Miller
Jul 20 '11 at 15:11
2
@Chad Miller, Oh, of course - that would be the obvious place for a user of powershell to look! /end-sarcasm. Thanks.
– drozzy
Jul 20 '11 at 19:16
ss64.com is also an obvious place to look period; though granted, the answer at ss64.com/ps/syntax-redirection.html is only implicit
– nik.shornikov
Apr 29 '15 at 18:51
1
The TechNet worked fine when I tried it.
– Peter Mortensen
Oct 16 '17 at 21:14
add a comment |
2
That looks backwards :-(
– drozzy
Jul 20 '11 at 14:11
7
Redirection was covered in a Scripting Guys post using Get-Content blogs.technet.com/b/heyscriptingguy/archive/2011/07/16/…
– Chad Miller
Jul 20 '11 at 15:11
2
@Chad Miller, Oh, of course - that would be the obvious place for a user of powershell to look! /end-sarcasm. Thanks.
– drozzy
Jul 20 '11 at 19:16
ss64.com is also an obvious place to look period; though granted, the answer at ss64.com/ps/syntax-redirection.html is only implicit
– nik.shornikov
Apr 29 '15 at 18:51
1
The TechNet worked fine when I tried it.
– Peter Mortensen
Oct 16 '17 at 21:14
2
2
That looks backwards :-(
– drozzy
Jul 20 '11 at 14:11
That looks backwards :-(
– drozzy
Jul 20 '11 at 14:11
7
7
Redirection was covered in a Scripting Guys post using Get-Content blogs.technet.com/b/heyscriptingguy/archive/2011/07/16/…
– Chad Miller
Jul 20 '11 at 15:11
Redirection was covered in a Scripting Guys post using Get-Content blogs.technet.com/b/heyscriptingguy/archive/2011/07/16/…
– Chad Miller
Jul 20 '11 at 15:11
2
2
@Chad Miller, Oh, of course - that would be the obvious place for a user of powershell to look! /end-sarcasm. Thanks.
– drozzy
Jul 20 '11 at 19:16
@Chad Miller, Oh, of course - that would be the obvious place for a user of powershell to look! /end-sarcasm. Thanks.
– drozzy
Jul 20 '11 at 19:16
ss64.com is also an obvious place to look period; though granted, the answer at ss64.com/ps/syntax-redirection.html is only implicit
– nik.shornikov
Apr 29 '15 at 18:51
ss64.com is also an obvious place to look period; though granted, the answer at ss64.com/ps/syntax-redirection.html is only implicit
– nik.shornikov
Apr 29 '15 at 18:51
1
1
The TechNet worked fine when I tried it.
– Peter Mortensen
Oct 16 '17 at 21:14
The TechNet worked fine when I tried it.
– Peter Mortensen
Oct 16 '17 at 21:14
add a comment |
I don't think MySQL will accept PowerShell objects piped to it - as Stephan says though, you could use Get-Content and pipe it to the next command.
Check out Stack Overflow question Is PowerShell ready to replace my Cygwin shell on Windows? for reasons on why they haven't copied Unix shells.
Sorry, but where are there reasons? It's just comparisons it seems...
– drozzy
Jul 20 '11 at 19:17
Did you read Jeffery Snover's comment? He talks about the reasons.
– Matt
Jul 20 '11 at 20:07
I see no reasons on input redirects in particular, and I am really not interested in Unix vs Windows tools. I was only curious about the one particular tool. After all, the output redirection ">" is implemented!
– drozzy
Jul 22 '11 at 16:59
I was considering the question more generically in why certain aspects of powershell do not implement the same functions as other shells. I didn't say it answered why < wasn't implemented though it provides insight into the design process,
– Matt
Jul 24 '11 at 10:50
add a comment |
I don't think MySQL will accept PowerShell objects piped to it - as Stephan says though, you could use Get-Content and pipe it to the next command.
Check out Stack Overflow question Is PowerShell ready to replace my Cygwin shell on Windows? for reasons on why they haven't copied Unix shells.
Sorry, but where are there reasons? It's just comparisons it seems...
– drozzy
Jul 20 '11 at 19:17
Did you read Jeffery Snover's comment? He talks about the reasons.
– Matt
Jul 20 '11 at 20:07
I see no reasons on input redirects in particular, and I am really not interested in Unix vs Windows tools. I was only curious about the one particular tool. After all, the output redirection ">" is implemented!
– drozzy
Jul 22 '11 at 16:59
I was considering the question more generically in why certain aspects of powershell do not implement the same functions as other shells. I didn't say it answered why < wasn't implemented though it provides insight into the design process,
– Matt
Jul 24 '11 at 10:50
add a comment |
I don't think MySQL will accept PowerShell objects piped to it - as Stephan says though, you could use Get-Content and pipe it to the next command.
Check out Stack Overflow question Is PowerShell ready to replace my Cygwin shell on Windows? for reasons on why they haven't copied Unix shells.
I don't think MySQL will accept PowerShell objects piped to it - as Stephan says though, you could use Get-Content and pipe it to the next command.
Check out Stack Overflow question Is PowerShell ready to replace my Cygwin shell on Windows? for reasons on why they haven't copied Unix shells.
edited Oct 16 '17 at 21:15
Peter Mortensen
13.6k1986111
13.6k1986111
answered Jul 20 '11 at 14:37
MattMatt
1,619919
1,619919
Sorry, but where are there reasons? It's just comparisons it seems...
– drozzy
Jul 20 '11 at 19:17
Did you read Jeffery Snover's comment? He talks about the reasons.
– Matt
Jul 20 '11 at 20:07
I see no reasons on input redirects in particular, and I am really not interested in Unix vs Windows tools. I was only curious about the one particular tool. After all, the output redirection ">" is implemented!
– drozzy
Jul 22 '11 at 16:59
I was considering the question more generically in why certain aspects of powershell do not implement the same functions as other shells. I didn't say it answered why < wasn't implemented though it provides insight into the design process,
– Matt
Jul 24 '11 at 10:50
add a comment |
Sorry, but where are there reasons? It's just comparisons it seems...
– drozzy
Jul 20 '11 at 19:17
Did you read Jeffery Snover's comment? He talks about the reasons.
– Matt
Jul 20 '11 at 20:07
I see no reasons on input redirects in particular, and I am really not interested in Unix vs Windows tools. I was only curious about the one particular tool. After all, the output redirection ">" is implemented!
– drozzy
Jul 22 '11 at 16:59
I was considering the question more generically in why certain aspects of powershell do not implement the same functions as other shells. I didn't say it answered why < wasn't implemented though it provides insight into the design process,
– Matt
Jul 24 '11 at 10:50
Sorry, but where are there reasons? It's just comparisons it seems...
– drozzy
Jul 20 '11 at 19:17
Sorry, but where are there reasons? It's just comparisons it seems...
– drozzy
Jul 20 '11 at 19:17
Did you read Jeffery Snover's comment? He talks about the reasons.
– Matt
Jul 20 '11 at 20:07
Did you read Jeffery Snover's comment? He talks about the reasons.
– Matt
Jul 20 '11 at 20:07
I see no reasons on input redirects in particular, and I am really not interested in Unix vs Windows tools. I was only curious about the one particular tool. After all, the output redirection ">" is implemented!
– drozzy
Jul 22 '11 at 16:59
I see no reasons on input redirects in particular, and I am really not interested in Unix vs Windows tools. I was only curious about the one particular tool. After all, the output redirection ">" is implemented!
– drozzy
Jul 22 '11 at 16:59
I was considering the question more generically in why certain aspects of powershell do not implement the same functions as other shells. I didn't say it answered why < wasn't implemented though it provides insight into the design process,
– Matt
Jul 24 '11 at 10:50
I was considering the question more generically in why certain aspects of powershell do not implement the same functions as other shells. I didn't say it answered why < wasn't implemented though it provides insight into the design process,
– Matt
Jul 24 '11 at 10:50
add a comment |
Thanks for contributing an answer to Stack Overflow!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f6763086%2fwhy-is-input-redirect-not-implemented-in-powershell%23new-answer', 'question_page');
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
2
Since you gave piping a script to
mysql
as your example, I thought I should point you to this in case you try to use Powershell to pipe a backup.– Joel B Fant
Jul 20 '11 at 14:34
That is exactly what I was looking for. Granted, not the best solution, but a nice hack, without having to switch back to dos-prompt.
– drozzy
Jul 20 '11 at 19:19
A year and a half later, I still don't have an answer to this specific question of why input redirect was not implemented.
– Joel B Fant
Feb 14 '13 at 4:08