MIME-Version: 1.0
References: <27d9076-c416-7847-7bd-159a5c3ee38a@appl-ecosys.com>
In-Reply-To: <27d9076-c416-7847-7bd-159a5c3ee38a@appl-ecosys.com>
From: "David G. Johnston" <david.g.johnston@gmail.com>
Date: Wed, 12 Jun 2024 15:12:53 -0700
Message-ID: <CAKFQuwbpWc97huJPbQSQ_F1JoEk+X_3KTbSDGdv+8ueUhktO+g@mail.gmail.com>
Subject: Re: Definging columns for INSERT statements
To: Rich Shepard <rshepard@appl-ecosys.com>
Cc: pgsql-general@lists.postgresql.org
Content-Type: multipart/alternative; boundary="000000000000473fee061ab8b19b"
Archived-At: <https://www.postgresql.org/message-id/CAKFQuwbpWc97huJPbQSQ_F1JoEk%2BX_3KTbSDGdv%2B8ueUhktO%2Bg%40mail.gmail.com>
Precedence: bulk

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

On Wed, Jun 12, 2024 at 2:11=E2=80=AFPM Rich Shepard <rshepard@appl-ecosys.=
com>
wrote:

> I have > 100 rows to add to a table using INSERT INTO statements. I want
> the
> PK to be the next value in the sequence. Would this be the appropriate
> syntax for the columns to be entered?
>

The whole point of the server is to parse text and tell you if it has
syntax errors and then, if not, execute what you gave it.


> INSERT INTO people (person_nbr
> DEFAULT('people_person_nbr_seq'),lname,fname,job_title DEFAULT
> 'Contact',company_nbr,loc_nbr,direct_phone,cell_phone,email,active
> DEFAULT('true')) VALUES
>

https://www.postgresql.org/docs/current/sql-insert.html

Not sure where you got the idea that something besides a plain column name
can appear in the optional parentheses after the table name.

David J.

--000000000000473fee061ab8b19b
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 Wed, Jun 12, 2024 at 2:11=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">I have &gt; 100 rows to add to a table usi=
ng INSERT INTO statements. I want the<br>
PK to be the next value in the sequence. Would this be the appropriate<br>
syntax for the columns to be entered?<br></blockquote><div><br></div><div c=
lass=3D"gmail_default" style=3D"font-family:arial,helvetica,sans-serif">The=
 whole=C2=A0point of the server is to parse text and tell you if it has syn=
tax errors and then, if not, execute=C2=A0what you gave it.</div><div class=
=3D"gmail_default" style=3D"font-family:arial,helvetica,sans-serif"><br></d=
iv><blockquote class=3D"gmail_quote" style=3D"margin:0px 0px 0px 0.8ex;bord=
er-left:1px solid rgb(204,204,204);padding-left:1ex">
<br>
INSERT INTO people (person_nbr DEFAULT(&#39;people_person_nbr_seq&#39;),lna=
me,fname,job_title DEFAULT &#39;Contact&#39;,company_nbr,loc_nbr,direct_pho=
ne,cell_phone,email,active DEFAULT(&#39;true&#39;)) VALUES<br></blockquote>=
<div><br></div><div><a href=3D"https://www.postgresql.org/docs/current/sql-=
insert.html">https://www.postgresql.org/docs/current/sql-insert.html</a><br=
></div><div><br></div><div><div class=3D"gmail_default" style=3D"font-famil=
y:arial,helvetica,sans-serif">Not sure where you got the idea that somethin=
g besides a plain column name can appear in the optional parentheses after =
the table name.</div><div class=3D"gmail_default" style=3D"font-family:aria=
l,helvetica,sans-serif"><br></div><div class=3D"gmail_default" style=3D"fon=
t-family:arial,helvetica,sans-serif">David J.</div><br></div></div></div>

--000000000000473fee061ab8b19b--