MIME-Version: 1.0
References: <7da8ec9-089-74ce-eb3-c88889b62c64@appl-ecosys.com>
 <20240610212715.aqpipehoa5xxmrmf@hjp.at> <153620cc-69f4-d850-ae36-2224dbd7f5ae@appl-ecosys.com>
In-Reply-To: <153620cc-69f4-d850-ae36-2224dbd7f5ae@appl-ecosys.com>
From: "David G. Johnston" <david.g.johnston@gmail.com>
Date: Mon, 10 Jun 2024 15:00:55 -0700
Message-ID: <CAKFQuwZGsnB680tLxDyrkDoz-BNesF=s1xL1CCGsieLK=5P1Vg@mail.gmail.com>
Subject: Re: Multiple tables row insertions from single psql input file
To: Rich Shepard <rshepard@appl-ecosys.com>
Cc: pgsql-general@lists.postgresql.org
Content-Type: multipart/alternative; boundary="000000000000d4267b061a904a4f"
Archived-At: <https://www.postgresql.org/message-id/CAKFQuwZGsnB680tLxDyrkDoz-BNesF%3Ds1xL1CCGsieLK%3D5P1Vg%40mail.gmail.com>
Precedence: bulk

--000000000000d4267b061a904a4f
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

On Mon, Jun 10, 2024 at 2:58=E2=80=AFPM Rich Shepard <rshepard@appl-ecosys.=
com>
wrote:

>
> INSERT into companies (company_nbr,company_name,industry,status) VALUES
> nextval('companies_org_nbr_seq'),'Acme','Manufacturing','Opportunity'),
> nextval('companies_org_nbr_seq'),'Baker','Livestock','Opportunity');
>
> Running:
> $ psql -U rshepard -d bustrac -f test-script.sql
> psql:test-script.sql:3: ERROR:  syntax error at or near "nextval"
> LINE 2: nextval('companies_org_nbr_seq'),'Acme','Manufacturing','Opp...
>          ^
> What have I missed?
>
>
Values introduces literal records/rows.  Rows are written within
parentheses.
Values (..., ...), (..., ...)

You seem to have the closing parenthesis but not the opening one.

David J.

--000000000000d4267b061a904a4f
Content-Type: text/html; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

<div dir=3D"ltr"><div dir=3D"ltr"><div class=3D"gmail_default" style=3D"fon=
t-family:arial,helvetica,sans-serif"><span style=3D"font-family:Arial,Helve=
tica,sans-serif">On Mon, Jun 10, 2024 at 2:58=E2=80=AFPM Rich Shepard &lt;<=
a href=3D"mailto:rshepard@appl-ecosys.com">rshepard@appl-ecosys.com</a>&gt;=
 wrote:</span><br></div></div><div class=3D"gmail_quote"><blockquote class=
=3D"gmail_quote" style=3D"margin:0px 0px 0px 0.8ex;border-left:1px solid rg=
b(204,204,204);padding-left:1ex"><br>
INSERT into companies (company_nbr,company_name,industry,status) VALUES <br=
>
nextval(&#39;companies_org_nbr_seq&#39;),&#39;Acme&#39;,&#39;Manufacturing&=
#39;,&#39;Opportunity&#39;),<br>
nextval(&#39;companies_org_nbr_seq&#39;),&#39;Baker&#39;,&#39;Livestock&#39=
;,&#39;Opportunity&#39;);<br>
<br>
Running:<br>
$ psql -U rshepard -d bustrac -f test-script.sql <br>
psql:test-script.sql:3: ERROR:=C2=A0 syntax error at or near &quot;nextval&=
quot;<br>
LINE 2: nextval(&#39;companies_org_nbr_seq&#39;),&#39;Acme&#39;,&#39;Manufa=
cturing&#39;,&#39;Opp...<br>
=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0^<br>
What have I missed?<br><br></blockquote><div><br></div><div class=3D"gmail_=
default" style=3D"font-family:arial,helvetica,sans-serif">Values introduces=
 literal records/rows.=C2=A0 Rows are written within parentheses.</div><div=
 class=3D"gmail_default" style=3D"font-family:arial,helvetica,sans-serif">V=
alues (..., ...), (..., ...)</div><div class=3D"gmail_default" style=3D"fon=
t-family:arial,helvetica,sans-serif"><br></div><div class=3D"gmail_default"=
 style=3D"font-family:arial,helvetica,sans-serif">You seem to have the=C2=
=A0closing parenthesis but not the opening one.</div><div class=3D"gmail_de=
fault" style=3D"font-family:arial,helvetica,sans-serif"><br></div><div clas=
s=3D"gmail_default" style=3D"font-family:arial,helvetica,sans-serif">David =
J.</div><div class=3D"gmail_default" style=3D"font-family:arial,helvetica,s=
ans-serif"><br></div></div></div>

--000000000000d4267b061a904a4f--