Follow along with the video below to see how to install our site as a web app on your home screen.
Anmerkung: This feature may not be available in some browsers.
test=# create table genkin(datum date);
CREATE TABLE
test=*# insert into genkin select * from generate_series('2000-01-01'::date, '2000-01-30'::date, '1day'::interval);
INSERT 0 30
test=*# select * from genkin ;
datum
------------
2000-01-01
2000-01-02
2000-01-03
2000-01-04
2000-01-05
2000-01-06
2000-01-07
2000-01-08
2000-01-09
2000-01-10
2000-01-11
2000-01-12
2000-01-13
2000-01-14
2000-01-15
2000-01-16
2000-01-17
2000-01-18
2000-01-19
2000-01-20
2000-01-21
2000-01-22
2000-01-23
2000-01-24
2000-01-25
2000-01-26
2000-01-27
2000-01-28
2000-01-29
2000-01-30
(30 rows)
test=*#
Ich will zwischen zwei Zeilen schreiben.
test=# create table Genkin(i int);
CREATE TABLE
test=*# insert into genkin values (1);
INSERT 0 1
test=*# insert into genkin values (2);
INSERT 0 1
test=*# insert into genkin values (3);
INSERT 0 1
test=*# update genkin set i = 2 where i = 2;
UPDATE 1
test=*# insert into genkin values (4);
INSERT 0 1
test=*# select * from genkin ;
i
---
1
3
2
4
(4 rows)
test=*#
Er sucht Update,