Styjun

crippling fear of hellfire &, damnation, please help?

Word for an event that will likely never happen again

Generate Brainfuck for the numbers 1–255

Are there any other rule mechanics that could grant Thieves' Cant?

Are differences between uniformly distributed numbers uniformly distributed?

Translation of "I don't have anything to smile about"

Programming of ICs in general (MCU / FPGA / Serdes IC)

Do I have to cite common CS algorithms?

A torrent of foreign terms

Website error: "Walmart can’t use this browser"

Why aren't rainbows blurred-out into nothing after they are produced?

If clocks themselves are based on light signals, wouldn't we expect the measured speed of light to always be the same constant?

If you know the location of an invisible creature, can you attack it?

How make an image of my entire usb flash drive?

What's this phrase on the wall of a toilet of a French château ?

Iteratively and adaptively increasing the network size during training

Does fossil fuels use since 1990 account for half of all the fossil fuels used in history?

What is a good class if we remove subclasses?

How far did Gandalf and the Balrog drop from the bridge in Moria?

Took GRE two times, same scores with minor differences - worth sending both?

Are those flyers about apartment purchase a scam?

80's/90's superhero cartoon with a man on fire and a man who made ice runways like Frozone

How to take the beginning and end parts of a list with simpler syntax?

Is there any way to stop a user from creating executables and running them?

Problem executing a PostgreSQL SQL script on Ubuntu Linux

Import SQL dump into PostgreSQL database“use database_name” command in PostgreSQLHow to install the JDK on Ubuntu LinuxCreateuser: could not connect to database postgres: FATAL: role “tom” does not existExecution of a python script from ubuntu shell`pg_tblspc` missing after installation of latest version of OS X (Yosemite or El Capitan)How to create User/Database in script for Docker PostgresExecuting postgres script using jenkinsrun bash script containing postgresql script failedCall a PostgreSQL function in bash script

.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty margin-bottom:0;

-1

I would like to execute a SQL script that will create a database in Postgres. It produces the message:

bash: syntax error near unexpected token 'newline'

The script is:

 postgres@tom: /home/tom$ psql -1q test test <script.sql 2>

postgresql ubuntu sh

share|improve this question

edited Mar 27 at 11:00

Laurenz Albe

61.8k1111 gold badges4444 silver badges6565 bronze badges

asked Mar 27 at 10:18

TomBTomB

522 bronze badges

• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  It's not clear what you expect 2> to actually do; it is definitely a syntax error. The proper redirection syntax is 2>filename or 2>&n where n is the number of an open file descriptor.
  
  – tripleee
  Mar 27 at 11:03
  
  

  
  
  
  

add a comment | 

-1

I would like to execute a SQL script that will create a database in Postgres. It produces the message:

bash: syntax error near unexpected token 'newline'

The script is:

 postgres@tom: /home/tom$ psql -1q test test <script.sql 2>

postgresql ubuntu sh

share|improve this question

edited Mar 27 at 11:00

Laurenz Albe

61.8k1111 gold badges4444 silver badges6565 bronze badges

asked Mar 27 at 10:18

TomBTomB

522 bronze badges

• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  It's not clear what you expect 2> to actually do; it is definitely a syntax error. The proper redirection syntax is 2>filename or 2>&n where n is the number of an open file descriptor.
  
  – tripleee
  Mar 27 at 11:03
  
  

  
  
  
  

add a comment | 

I would like to execute a SQL script that will create a database in Postgres. It produces the message:

bash: syntax error near unexpected token 'newline'

The script is:

 postgres@tom: /home/tom$ psql -1q test test <script.sql 2>

postgresql ubuntu sh

share|improve this question

edited Mar 27 at 11:00

Laurenz Albe

61.8k1111 gold badges4444 silver badges6565 bronze badges

asked Mar 27 at 10:18

TomBTomB

522 bronze badges

bash: syntax error near unexpected token 'newline'

 postgres@tom: /home/tom$ psql -1q test test <script.sql 2>

share|improve this question

edited Mar 27 at 11:00

Laurenz Albe

61.8k1111 gold badges4444 silver badges6565 bronze badges

asked Mar 27 at 10:18

TomBTomB

522 bronze badges

share|improve this question

edited Mar 27 at 11:00

Laurenz Albe

61.8k1111 gold badges4444 silver badges6565 bronze badges

asked Mar 27 at 10:18

TomBTomB

522 bronze badges

edited Mar 27 at 11:00

Laurenz Albe

61.8k1111 gold badges4444 silver badges6565 bronze badges

edited Mar 27 at 11:00

Laurenz Albe

61.8k1111 gold badges4444 silver badges6565 bronze badges

asked Mar 27 at 10:18

TomBTomB

522 bronze badges

asked Mar 27 at 10:18

TomBTomB

522 bronze badges

1 Answer
1

active

oldest

votes

0

If you want to redirect standard error to standard output, you should run

psql -1q -d test -U test -f script.sql 2>&1

share|improve this answer

answered Mar 27 at 10:57

Laurenz AlbeLaurenz Albe

61.8k1111 gold badges4444 silver badges6565 bronze badges

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
);



);

draft saved

draft discarded

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

Name

Email

Required, but never shown

StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f55374782%2fproblem-executing-a-postgresql-sql-script-on-ubuntu-linux%23new-answer', 'question_page');

);

Post as a guest

Name

Email

Required, but never shown

0

If you want to redirect standard error to standard output, you should run

psql -1q -d test -U test -f script.sql 2>&1

share|improve this answer

answered Mar 27 at 10:57

Laurenz AlbeLaurenz Albe

61.8k1111 gold badges4444 silver badges6565 bronze badges

add a comment | 

0

If you want to redirect standard error to standard output, you should run

psql -1q -d test -U test -f script.sql 2>&1

share|improve this answer

answered Mar 27 at 10:57

Laurenz AlbeLaurenz Albe

61.8k1111 gold badges4444 silver badges6565 bronze badges

add a comment | 

If you want to redirect standard error to standard output, you should run

psql -1q -d test -U test -f script.sql 2>&1

share|improve this answer

answered Mar 27 at 10:57

Laurenz AlbeLaurenz Albe

61.8k1111 gold badges4444 silver badges6565 bronze badges

psql -1q -d test -U test -f script.sql 2>&1

share|improve this answer

answered Mar 27 at 10:57

Laurenz AlbeLaurenz Albe

61.8k1111 gold badges4444 silver badges6565 bronze badges

answered Mar 27 at 10:57

Laurenz AlbeLaurenz Albe

61.8k1111 gold badges4444 silver badges6565 bronze badges

answered Mar 27 at 10:57

Laurenz AlbeLaurenz Albe

61.8k1111 gold badges4444 silver badges6565 bronze badges