AximX51V

AximX51V

Homebrewのインストールでいろいろやったこと 　　Python編

実行環境：Apple M1 Pro　macOS Ventura 13.2 ターミナル -bash 自分は、brew: command not fond　と表示されたので を実行した。下記のエラーが出て結果はできなかっ…

AximX51V
AximX51V
1年前

INNER JOIN構文 testdb=# \d member Table test.member test.departmen

testdb=# SELECT * FROM member; no | name | tel | groupno ----+------+-------------+--------- 1 | 石川 | 01201234567 | 2 2 | 鈴木 | 01201234568 |…

AximX51V
AximX51V
2年前

testdb=# \z itemとREVOKE

testdb=# \z item Access privileges Schema | Name | Type | Access privileges | Column privileges | Policies --------+----…

AximX51V
AximX51V
2年前

集合演算は和集合 testdb=# \d projectA public.projecta public.projectb

testdb=# \d projectA Table "public.projecta" Column | Type | Collation | Nullable | Default --------+-------------------+-------…

AximX51V
AximX51V
2年前

NULLを渡すと処理を実行せずにNULLを返す　testdb=# \d Table func1.sample

testdb=# \df List of functions Schema | Name | Result data type | Argument data types | Type --------+-----------------+--…

AximX51V
AximX51V
2年前

NATURAL FULL OUTER JOIN testdb=# \d public.testdb public.department

testdb=# SELECT * FROM member; no | name | tel | groupno | boss ----+------+------------+---------+-------- 1 | 佐藤 | 1201234567 | 2 | 佐々木 …

AximX51V
AximX51V
2年前

LEFT OUTER JOIN testdb=# \d test.member test.department

testdb=# SELECT * FROM member; no | name | tel | groupno ----+------+-------------+--------- 1 | 石川 | 01201234567 | 2 2 | 鈴木 | 01201234568 |…

AximX51V
AximX51V
2年前

examdb=# \d test1.sample1 test1.sample2 INHERITSコマンド

examdb=# \d sample1; Table "test1.sample1" Column | Type | Collation | Nullable | Default --------+-----------------------…

AximX51V
AximX51V
2年前

FULL OUTER JOIN

testdb=# \d member Table "public.member" Column | Type | Collation | Nullable | Default ---------+---…

AximX51V
AximX51V
2年前

EXISTSとNOT EXISTS　その2

testdb=# \d zooA Table "public.zooa" Column | Type | Collation | Nullable | Default --------+---------+-----------+----------+--------- name …

AximX51V
AximX51V
2年前

NULLを返す関数を呼ぶトリガーを作成

testdb=# \df List of functions Schema | Name | Result data type | Argument data types | Type --------+-----------------+--…

AximX51V
AximX51V
2年前

RIGHT OUTER JOIN postgres=# \d shopa_shoes postgres=# \d shopb_shoes

postgres=# \d shopa_shoes Table "public.shopa_shoes" Column | Type | Collation | Nullable | Default…

AximX51V
AximX51V
2年前

Table "test.member" "test.department" OUTER JOIN句

testdb=# \d member Table "test.member" Column | Type | Collation | Nullable | Default ---------+-----------------------+…

AximX51V
AximX51V
2年前

組み込み関数

testdb=# SELECT extract(minute from now()); date_part ----------- 37(1 row) testdb=# SELECT date_part('minute', current_timestamp); date_part ----------…

AximX51V
AximX51V
2年前

testdb=# \d test.sample　ユニーク制約

testdb=# \d sample Table "test.sample" Column | Type | Collation | Nullable | Default -----------+---------+-----------+-------…

AximX51V
AximX51V
2年前

postgres=# \d menber Table "test.member"

postgres=# \d member Table "test.member" Column | Type | Collation | Nullable | Default --------+-------------------+----------…

AximX51V
AximX51V
2年前
AximX51V

AximX51V

Homebrewのインストールでいろいろやったこと 　　Python編

Homebrewのインストールでいろいろやったこと 　　Python編

実行環境：Apple M1 Pro　macOS Ventura 13.2
ターミナル -bash

自分は、brew: command not fond　と表示されたので

を実行した。下記のエラーが出て結果はできなかった。

xcrun: error: unable to load libxcrun

ここからいろいろいじってみた。以前Visual StudioをインストールしてPython

もっとみる
AximX51V

AximX51V

INNER JOIN構文 testdb=# \d member Table test.member test.departmen

testdb=# SELECT * FROM member; no | name | tel | groupno ----+------+-------------+--------- 1 | 石川 | 01201234567 | 2 2 | 鈴木 | 01201234568 | 3 3 | 児玉 | 01201234569 | 2(3 r

もっとみる
AximX51V

AximX51V

testdb=# \z itemとREVOKE

testdb=# \z item Access privileges Schema | Name | Type | Access privileges | Column privileges | Policies --------+------+-------+---------------------------+-

もっとみる
AximX51V

AximX51V

集合演算は和集合 testdb=# \d projectA public.projecta public.projectb

testdb=# \d projectA Table "public.projecta" Column | Type | Collation | Nullable | Default --------+-------------------+-----------+----------+--------- member | chara

もっとみる
AximX51V

AximX51V

NULLを渡すと処理を実行せずにNULLを返す　testdb=# \d Table func1.sample

testdb=# \df List of functions Schema | Name | Result data type | Argument data types | Type --------+-----------------+------------------+---------------------+-

もっとみる
AximX51V

AximX51V

NATURAL FULL OUTER JOIN testdb=# \d public.testdb public.department

testdb=# SELECT * FROM member; no | name | tel | groupno | boss ----+------+------------+---------+-------- 1 | 佐藤 | 1201234567 | 2 | 佐々木 2 | 鈴木 | 1201234568 | 1 | 原田 3 | 渡辺 |

もっとみる
AximX51V

AximX51V

LEFT OUTER JOIN testdb=# \d test.member test.department

testdb=# SELECT * FROM member; no | name | tel | groupno ----+------+-------------+--------- 1 | 石川 | 01201234567 | 2 2 | 鈴木 | 01201234568 | 3 3 | 児玉 | 01201234569 | 2(3 r

もっとみる
AximX51V

AximX51V

examdb=# \d test1.sample1 test1.sample2 INHERITSコマンド

examdb=# \d sample1; Table "test1.sample1" Column | Type | Collation | Nullable | Default --------+-----------------------+-----------+----------+--------- no

もっとみる
AximX51V

AximX51V

FULL OUTER JOIN

testdb=# \d member Table "public.member" Column | Type | Collation | Nullable | Default ---------+---------+-----------+----------+----------

もっとみる
AximX51V

AximX51V

EXISTSとNOT EXISTS　その2

testdb=# \d zooA Table "public.zooa" Column | Type | Collation | Nullable | Default --------+---------+-----------+----------+--------- name | text | | | num

もっとみる
AximX51V

AximX51V

NULLを返す関数を呼ぶトリガーを作成

testdb=# \df List of functions Schema | Name | Result data type | Argument data types | Type --------+-----------------+------------------+---------------------+-

もっとみる
AximX51V

AximX51V

RIGHT OUTER JOIN postgres=# \d shopa_shoes postgres=# \d shopb_shoes

postgres=# \d shopa_shoes Table "public.shopa_shoes" Column | Type | Collation | Nullable | Default --------+--------------

もっとみる
AximX51V

AximX51V

Table "test.member" "test.department" OUTER JOIN句

testdb=# \d member Table "test.member" Column | Type | Collation | Nullable | Default ---------+-----------------------+-----------+----------+--------- no

もっとみる
AximX51V

AximX51V

組み込み関数

testdb=# SELECT extract(minute from now()); date_part ----------- 37(1 row)

testdb=# SELECT date_part('minute', current_timestamp); date_part ----------- 38(1 row)

現在の日時

testdb=# SELE

もっとみる
AximX51V

AximX51V

testdb=# \d test.sample　ユニーク制約

testdb=# \d sample Table "test.sample" Column | Type | Collation | Nullable | Default -----------+---------+-----------+----------+---------------- id | integer

もっとみる
AximX51V

AximX51V

postgres=# \d menber Table "test.member"

postgres=# \d member Table "test.member" Column | Type | Collation | Nullable | Default --------+-------------------+-----------+----------+--------- id | characte

もっとみる