{"id":11578,"date":"2023-05-12T07:08:55","date_gmt":"2023-05-11T22:08:55","guid":{"rendered":"https:\/\/lab4ict.com\/system\/?p=11578"},"modified":"2023-07-14T20:57:05","modified_gmt":"2023-07-14T11:57:05","slug":"postgresql%e3%81%a7%e3%83%86%e3%83%bc%e3%83%96%e3%83%ab%e3%81%ab%e3%83%87%e3%83%bc%e3%82%bf%e3%82%92insert%e3%81%99%e3%82%8b%ef%bc%81","status":"publish","type":"post","link":"https:\/\/lab4ict.com\/system\/archives\/11578","title":{"rendered":"PostgreSQL\u3067\u30c6\u30fc\u30d6\u30eb\u306b\u30c7\u30fc\u30bf\u3092INSERT\u3059\u308b\uff01"},"content":{"rendered":"

PostgreSQL\u3067\u30c6\u30fc\u30d6\u30eb\u306b\u30c7\u30fc\u30bf\u3092INSERT\u3057\u307e\u3059\u3002
\n<\/p>\n

\u30c6\u30fc\u30d6\u30eb\u306e\u30ab\u30e9\u30e0\u306e\u60c5\u5831\u3092\u78ba\u8a8d\u3059\u308b\uff01<\/h2>\n

\u30c7\u30fc\u30bf\u3092INSERT\u3059\u308bauthentication\u30c6\u30fc\u30d6\u30eb\u306e\u30ab\u30e9\u30e0\u306e\u60c5\u5831\u3092\u78ba\u8a8d\u3057\u307e\u3059\u3002<\/p>\n

\r\ninventory=# \\d authentication\r\n                       Table "public.authentication"\r\n   Column   |            Type             | Collation | Nullable | Default \r\n------------+-----------------------------+-----------+----------+---------\r\n user_id    | character varying(50)       |           | not null | \r\n username   | character varying(50)       |           | not null | \r\n password   | character varying(50)       |           | not null | \r\n email      | character varying(255)      |           | not null | \r\n created_on | timestamp without time zone |           | not null | \r\n last_login | timestamp without time zone |           |          | \r\nIndexes:\r\n    "authentication_pkey" PRIMARY KEY, btree (user_id)\r\n    "authentication_email_key" UNIQUE CONSTRAINT, btree (email)\r\n    "authentication_username_key" UNIQUE CONSTRAINT, btree (username)\r\n<\/pre>\n
\u30c7\u30fc\u30bf\u3092INSERT\u3059\u308b\uff01<\/h2>\n
authentication\u30c6\u30fc\u30d6\u30eb\u306b\u30c7\u30fc\u30bf\u3092INSERT\u3057\u307e\u3059\u3002<\/p>\n
\r\ninventory=# insert into authentication (user_id, username, password, email, created_on, last_login) values ('00000001', 'sysusr01', 'sysusr01', 'lab4ict@gmail.com', '2023-05-09 00:00:00', '2023-05-09 00:00:00');\r\nINSERT 0 1\r\n<\/pre>\n
\u30c7\u30fc\u30bf\u3092\u78ba\u8a8d\u3059\u308b\uff01<\/h2>\n
INSERT\u3057\u305f\u30c7\u30fc\u30bf\u3092SELECT\u6587\u3067\u78ba\u8a8d\u3057\u307e\u3059\u3002<\/p>\n
\r\ninventory=# select * from authentication;\r\n user_id  | username | password |       email       |     created_on      |     last_login      \r\n----------+----------+----------+-------------------+---------------------+---------------------\r\n 00000001 | sysusr01 | sysusr01 | lab4ict@gmail.com | 2023-05-09 00:00:00 | 2023-05-09 00:00:00\r\n(1 row)\r\n<\/pre>\n
\u304a\u308f\u308a\u306b<\/h2>\n
PostgreSQL\u306e\u30c6\u30fc\u30d6\u30eb\u3078\u306e\u30c7\u30fc\u30bfINSERT\u306f\u3001\u6a19\u6e96\u7684\u306aSQL\u6587\u3067\u5b9f\u884c\u3059\u308b\u3053\u3068\u304c\u3067\u304d\u307e\u3059\u3002<\/p>\n
\u53c2\u8003\u60c5\u5831<\/h2>\n