Mercurial > sqlpython

annotate sqlpython/pagila_test.txt @ 497:128aa57c4b8d

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
first try at switching postgres query to dbapiext form
author Catherine Devlin <catherine.devlin@gmail.com>
date Wed, 27 Oct 2010 10:04:31 -0400
parents
children c36e0aa695a4
rev   line source
497
128aa57c4b8d first try at switching postgres query to dbapiext form
Catherine Devlin <catherine.devlin@gmail.com>
parents:
diff changeset
1 """
128aa57c4b8d first try at switching postgres query to dbapiext form
Catherine Devlin <catherine.devlin@gmail.com>
parents:
diff changeset
2 Run these against a ``pagila`` database (user paglia, password paglia)
128aa57c4b8d first try at switching postgres query to dbapiext form
Catherine Devlin <catherine.devlin@gmail.com>
parents:
diff changeset
3 created from http://pgfoundry.org/projects/dbsamples/
128aa57c4b8d first try at switching postgres query to dbapiext form
Catherine Devlin <catherine.devlin@gmail.com>
parents:
diff changeset
4 """
128aa57c4b8d first try at switching postgres query to dbapiext form
Catherine Devlin <catherine.devlin@gmail.com>
parents:
diff changeset
5 SQL.No_Connection> connect postgres://pagila:pagila@localhost/pagila
128aa57c4b8d first try at switching postgres query to dbapiext form
Catherine Devlin <catherine.devlin@gmail.com>
parents:
diff changeset
6 0:pagila@pagila> set color off
128aa57c4b8d first try at switching postgres query to dbapiext form
Catherine Devlin <catherine.devlin@gmail.com>
parents:
diff changeset
7 colors - was: True
128aa57c4b8d first try at switching postgres query to dbapiext form
Catherine Devlin <catherine.devlin@gmail.com>
parents:
diff changeset
8 now: False
128aa57c4b8d first try at switching postgres query to dbapiext form
Catherine Devlin <catherine.devlin@gmail.com>
parents:
diff changeset
9 0:pagila@pagila> desc actor
128aa57c4b8d first try at switching postgres query to dbapiext form
Catherine Devlin <catherine.devlin@gmail.com>
parents:
diff changeset
10 BASE TABLE public.actor
128aa57c4b8d first try at switching postgres query to dbapiext form
Catherine Devlin <catherine.devlin@gmail.com>
parents:
diff changeset
11 Name Nullable Type
128aa57c4b8d first try at switching postgres query to dbapiext form
Catherine Devlin <catherine.devlin@gmail.com>
parents:
diff changeset
12 ----------- -------- ---------------------------
128aa57c4b8d first try at switching postgres query to dbapiext form
Catherine Devlin <catherine.devlin@gmail.com>
parents:
diff changeset
13 actor_id NOT NULL integer
128aa57c4b8d first try at switching postgres query to dbapiext form
Catherine Devlin <catherine.devlin@gmail.com>
parents:
diff changeset
14 first_name NOT NULL varchar(45)
128aa57c4b8d first try at switching postgres query to dbapiext form
Catherine Devlin <catherine.devlin@gmail.com>
parents:
diff changeset
15 last_name NOT NULL varchar(45)
128aa57c4b8d first try at switching postgres query to dbapiext form
Catherine Devlin <catherine.devlin@gmail.com>
parents:
diff changeset
16 last_update NOT NULL timestamp without time zone
128aa57c4b8d first try at switching postgres query to dbapiext form
Catherine Devlin <catherine.devlin@gmail.com>
parents:
diff changeset
17
128aa57c4b8d first try at switching postgres query to dbapiext form
Catherine Devlin <catherine.devlin@gmail.com>
parents:
diff changeset
18 0:pagila@pagila> desc actor\g
128aa57c4b8d first try at switching postgres query to dbapiext form
Catherine Devlin <catherine.devlin@gmail.com>
parents:
diff changeset
19 BASE TABLE public.actor
128aa57c4b8d first try at switching postgres query to dbapiext form
Catherine Devlin <catherine.devlin@gmail.com>
parents:
diff changeset
20
128aa57c4b8d first try at switching postgres query to dbapiext form
Catherine Devlin <catherine.devlin@gmail.com>
parents:
diff changeset
21
128aa57c4b8d first try at switching postgres query to dbapiext form
Catherine Devlin <catherine.devlin@gmail.com>
parents:
diff changeset
22 **** Row: 1
128aa57c4b8d first try at switching postgres query to dbapiext form
Catherine Devlin <catherine.devlin@gmail.com>
parents:
diff changeset
23 Name: actor_id
128aa57c4b8d first try at switching postgres query to dbapiext form
Catherine Devlin <catherine.devlin@gmail.com>
parents:
diff changeset
24 Nullable: NOT NULL
128aa57c4b8d first try at switching postgres query to dbapiext form
Catherine Devlin <catherine.devlin@gmail.com>
parents:
diff changeset
25 Type: integer
128aa57c4b8d first try at switching postgres query to dbapiext form
Catherine Devlin <catherine.devlin@gmail.com>
parents:
diff changeset
26
128aa57c4b8d first try at switching postgres query to dbapiext form
Catherine Devlin <catherine.devlin@gmail.com>
parents:
diff changeset
27 **** Row: 2
128aa57c4b8d first try at switching postgres query to dbapiext form
Catherine Devlin <catherine.devlin@gmail.com>
parents:
diff changeset
28 Name: first_name
128aa57c4b8d first try at switching postgres query to dbapiext form
Catherine Devlin <catherine.devlin@gmail.com>
parents:
diff changeset
29 Nullable: NOT NULL
128aa57c4b8d first try at switching postgres query to dbapiext form
Catherine Devlin <catherine.devlin@gmail.com>
parents:
diff changeset
30 Type: varchar(45)
128aa57c4b8d first try at switching postgres query to dbapiext form
Catherine Devlin <catherine.devlin@gmail.com>
parents:
diff changeset
31
128aa57c4b8d first try at switching postgres query to dbapiext form
Catherine Devlin <catherine.devlin@gmail.com>
parents:
diff changeset
32 **** Row: 3
128aa57c4b8d first try at switching postgres query to dbapiext form
Catherine Devlin <catherine.devlin@gmail.com>
parents:
diff changeset
33 Name: last_name
128aa57c4b8d first try at switching postgres query to dbapiext form
Catherine Devlin <catherine.devlin@gmail.com>
parents:
diff changeset
34 Nullable: NOT NULL
128aa57c4b8d first try at switching postgres query to dbapiext form
Catherine Devlin <catherine.devlin@gmail.com>
parents:
diff changeset
35 Type: varchar(45)
128aa57c4b8d first try at switching postgres query to dbapiext form
Catherine Devlin <catherine.devlin@gmail.com>
parents:
diff changeset
36
128aa57c4b8d first try at switching postgres query to dbapiext form
Catherine Devlin <catherine.devlin@gmail.com>
parents:
diff changeset
37 **** Row: 4
128aa57c4b8d first try at switching postgres query to dbapiext form
Catherine Devlin <catherine.devlin@gmail.com>
parents:
diff changeset
38 Name: last_update
128aa57c4b8d first try at switching postgres query to dbapiext form
Catherine Devlin <catherine.devlin@gmail.com>
parents:
diff changeset
39 Nullable: NOT NULL
128aa57c4b8d first try at switching postgres query to dbapiext form
Catherine Devlin <catherine.devlin@gmail.com>
parents:
diff changeset
40 Type: timestamp without time zone
128aa57c4b8d first try at switching postgres query to dbapiext form
Catherine Devlin <catherine.devlin@gmail.com>
parents:
diff changeset
41
128aa57c4b8d first try at switching postgres query to dbapiext form
Catherine Devlin <catherine.devlin@gmail.com>
parents:
diff changeset
42 0:pagila@pagila> \d -l actor\g
128aa57c4b8d first try at switching postgres query to dbapiext form
Catherine Devlin <catherine.devlin@gmail.com>
parents:
diff changeset
43 BASE TABLE public.actor
128aa57c4b8d first try at switching postgres query to dbapiext form
Catherine Devlin <catherine.devlin@gmail.com>
parents:
diff changeset
44
128aa57c4b8d first try at switching postgres query to dbapiext form
Catherine Devlin <catherine.devlin@gmail.com>
parents:
diff changeset
45
128aa57c4b8d first try at switching postgres query to dbapiext form
Catherine Devlin <catherine.devlin@gmail.com>
parents:
diff changeset
46 **** Row: 1
128aa57c4b8d first try at switching postgres query to dbapiext form
Catherine Devlin <catherine.devlin@gmail.com>
parents:
diff changeset
47 N: 1
128aa57c4b8d first try at switching postgres query to dbapiext form
Catherine Devlin <catherine.devlin@gmail.com>
parents:
diff changeset
48 Name: actor_id
128aa57c4b8d first try at switching postgres query to dbapiext form
Catherine Devlin <catherine.devlin@gmail.com>
parents:
diff changeset
49 Nullable: NOT NULL
128aa57c4b8d first try at switching postgres query to dbapiext form
Catherine Devlin <catherine.devlin@gmail.com>
parents:
diff changeset
50 Type: integer
128aa57c4b8d first try at switching postgres query to dbapiext form
Catherine Devlin <catherine.devlin@gmail.com>
parents:
diff changeset
51 Key: P
128aa57c4b8d first try at switching postgres query to dbapiext form
Catherine Devlin <catherine.devlin@gmail.com>
parents:
diff changeset
52 Default: nextval('actor_actor_id_seq'::regclass)
128aa57c4b8d first try at switching postgres query to dbapiext form
Catherine Devlin <catherine.devlin@gmail.com>
parents:
diff changeset
53 Comments:
128aa57c4b8d first try at switching postgres query to dbapiext form
Catherine Devlin <catherine.devlin@gmail.com>
parents:
diff changeset
54
128aa57c4b8d first try at switching postgres query to dbapiext form
Catherine Devlin <catherine.devlin@gmail.com>
parents:
diff changeset
55 **** Row: 2
128aa57c4b8d first try at switching postgres query to dbapiext form
Catherine Devlin <catherine.devlin@gmail.com>
parents:
diff changeset
56 N: 2
128aa57c4b8d first try at switching postgres query to dbapiext form
Catherine Devlin <catherine.devlin@gmail.com>
parents:
diff changeset
57 Name: first_name
128aa57c4b8d first try at switching postgres query to dbapiext form
Catherine Devlin <catherine.devlin@gmail.com>
parents:
diff changeset
58 Nullable: NOT NULL
128aa57c4b8d first try at switching postgres query to dbapiext form
Catherine Devlin <catherine.devlin@gmail.com>
parents:
diff changeset
59 Type: varchar(45)
128aa57c4b8d first try at switching postgres query to dbapiext form
Catherine Devlin <catherine.devlin@gmail.com>
parents:
diff changeset
60 Key:
128aa57c4b8d first try at switching postgres query to dbapiext form
Catherine Devlin <catherine.devlin@gmail.com>
parents:
diff changeset
61 Default:
128aa57c4b8d first try at switching postgres query to dbapiext form
Catherine Devlin <catherine.devlin@gmail.com>
parents:
diff changeset
62 Comments:
128aa57c4b8d first try at switching postgres query to dbapiext form
Catherine Devlin <catherine.devlin@gmail.com>
parents:
diff changeset
63
128aa57c4b8d first try at switching postgres query to dbapiext form
Catherine Devlin <catherine.devlin@gmail.com>
parents:
diff changeset
64 **** Row: 3
128aa57c4b8d first try at switching postgres query to dbapiext form
Catherine Devlin <catherine.devlin@gmail.com>
parents:
diff changeset
65 N: 3
128aa57c4b8d first try at switching postgres query to dbapiext form
Catherine Devlin <catherine.devlin@gmail.com>
parents:
diff changeset
66 Name: last_name
128aa57c4b8d first try at switching postgres query to dbapiext form
Catherine Devlin <catherine.devlin@gmail.com>
parents:
diff changeset
67 Nullable: NOT NULL
128aa57c4b8d first try at switching postgres query to dbapiext form
Catherine Devlin <catherine.devlin@gmail.com>
parents:
diff changeset
68 Type: varchar(45)
128aa57c4b8d first try at switching postgres query to dbapiext form
Catherine Devlin <catherine.devlin@gmail.com>
parents:
diff changeset
69 Key:
128aa57c4b8d first try at switching postgres query to dbapiext form
Catherine Devlin <catherine.devlin@gmail.com>
parents:
diff changeset
70 Default:
128aa57c4b8d first try at switching postgres query to dbapiext form
Catherine Devlin <catherine.devlin@gmail.com>
parents:
diff changeset
71 Comments:
128aa57c4b8d first try at switching postgres query to dbapiext form
Catherine Devlin <catherine.devlin@gmail.com>
parents:
diff changeset
72
128aa57c4b8d first try at switching postgres query to dbapiext form
Catherine Devlin <catherine.devlin@gmail.com>
parents:
diff changeset
73 **** Row: 4
128aa57c4b8d first try at switching postgres query to dbapiext form
Catherine Devlin <catherine.devlin@gmail.com>
parents:
diff changeset
74 N: 4
128aa57c4b8d first try at switching postgres query to dbapiext form
Catherine Devlin <catherine.devlin@gmail.com>
parents:
diff changeset
75 Name: last_update
128aa57c4b8d first try at switching postgres query to dbapiext form
Catherine Devlin <catherine.devlin@gmail.com>
parents:
diff changeset
76 Nullable: NOT NULL
128aa57c4b8d first try at switching postgres query to dbapiext form
Catherine Devlin <catherine.devlin@gmail.com>
parents:
diff changeset
77 Type: timestamp without time zone
128aa57c4b8d first try at switching postgres query to dbapiext form
Catherine Devlin <catherine.devlin@gmail.com>
parents:
diff changeset
78 Key:
128aa57c4b8d first try at switching postgres query to dbapiext form
Catherine Devlin <catherine.devlin@gmail.com>
parents:
diff changeset
79 Default: now()
128aa57c4b8d first try at switching postgres query to dbapiext form
Catherine Devlin <catherine.devlin@gmail.com>
parents:
diff changeset
80 Comments:
128aa57c4b8d first try at switching postgres query to dbapiext form
Catherine Devlin <catherine.devlin@gmail.com>
parents:
diff changeset
81
128aa57c4b8d first try at switching postgres query to dbapiext form
Catherine Devlin <catherine.devlin@gmail.com>
parents:
diff changeset
82
128aa57c4b8d first try at switching postgres query to dbapiext form
Catherine Devlin <catherine.devlin@gmail.com>
parents:
diff changeset
83 0:pagila@pagila> show constraints on actor
128aa57c4b8d first try at switching postgres query to dbapiext form
Catherine Devlin <catherine.devlin@gmail.com>
parents:
diff changeset
84 Constraints on BASE TABLE public.actor
128aa57c4b8d first try at switching postgres query to dbapiext form
Catherine Devlin <catherine.devlin@gmail.com>
parents:
diff changeset
85 Primary key "actor_pkey": (actor_id)
128aa57c4b8d first try at switching postgres query to dbapiext form
Catherine Devlin <catherine.devlin@gmail.com>
parents:
diff changeset
86
128aa57c4b8d first try at switching postgres query to dbapiext form
Catherine Devlin <catherine.devlin@gmail.com>
parents:
diff changeset
87 0:pagila@pagila> show indexes on actor
128aa57c4b8d first try at switching postgres query to dbapiext form
Catherine Devlin <catherine.devlin@gmail.com>
parents:
diff changeset
88 Indexes on BASE TABLE public.actor
128aa57c4b8d first try at switching postgres query to dbapiext form
Catherine Devlin <catherine.devlin@gmail.com>
parents:
diff changeset
89 idx_actor_last_name (last_name) btree
128aa57c4b8d first try at switching postgres query to dbapiext form
Catherine Devlin <catherine.devlin@gmail.com>
parents:
diff changeset
90
128aa57c4b8d first try at switching postgres query to dbapiext form
Catherine Devlin <catherine.devlin@gmail.com>
parents:
diff changeset
91 0:pagila@pagila> select actor_id, first_name, last_name from actor;3
128aa57c4b8d first try at switching postgres query to dbapiext form
Catherine Devlin <catherine.devlin@gmail.com>
parents:
diff changeset
92
128aa57c4b8d first try at switching postgres query to dbapiext form
Catherine Devlin <catherine.devlin@gmail.com>
parents:
diff changeset
93 actor_id first_name last_name
128aa57c4b8d first try at switching postgres query to dbapiext form
Catherine Devlin <catherine.devlin@gmail.com>
parents:
diff changeset
94 -------- ---------- ---------
128aa57c4b8d first try at switching postgres query to dbapiext form
Catherine Devlin <catherine.devlin@gmail.com>
parents:
diff changeset
95 1 PENELOPE GUINESS
128aa57c4b8d first try at switching postgres query to dbapiext form
Catherine Devlin <catherine.devlin@gmail.com>
parents:
diff changeset
96 2 NICK WAHLBERG
128aa57c4b8d first try at switching postgres query to dbapiext form
Catherine Devlin <catherine.devlin@gmail.com>
parents:
diff changeset
97 3 ED CHASE
128aa57c4b8d first try at switching postgres query to dbapiext form
Catherine Devlin <catherine.devlin@gmail.com>
parents:
diff changeset
98
128aa57c4b8d first try at switching postgres query to dbapiext form
Catherine Devlin <catherine.devlin@gmail.com>
parents:
diff changeset
99 3 rows selected.
128aa57c4b8d first try at switching postgres query to dbapiext form
Catherine Devlin <catherine.devlin@gmail.com>
parents:
diff changeset
100
128aa57c4b8d first try at switching postgres query to dbapiext form
Catherine Devlin <catherine.devlin@gmail.com>
parents:
diff changeset
101 0:pagila@pagila> select actor_id, first_name, last_name from actor\j3
128aa57c4b8d first try at switching postgres query to dbapiext form
Catherine Devlin <catherine.devlin@gmail.com>
parents:
diff changeset
102
128aa57c4b8d first try at switching postgres query to dbapiext form
Catherine Devlin <catherine.devlin@gmail.com>
parents:
diff changeset
103
128aa57c4b8d first try at switching postgres query to dbapiext form
Catherine Devlin <catherine.devlin@gmail.com>
parents:
diff changeset
104 {"actor": [
128aa57c4b8d first try at switching postgres query to dbapiext form
Catherine Devlin <catherine.devlin@gmail.com>
parents:
diff changeset
105 {"actor_id": 1, "first_name": "PENELOPE", "last_name": "GUINESS"},
128aa57c4b8d first try at switching postgres query to dbapiext form
Catherine Devlin <catherine.devlin@gmail.com>
parents:
diff changeset
106 {"actor_id": 2, "first_name": "NICK", "last_name": "WAHLBERG"},
128aa57c4b8d first try at switching postgres query to dbapiext form
Catherine Devlin <catherine.devlin@gmail.com>
parents:
diff changeset
107 {"actor_id": 3, "first_name": "ED", "last_name": "CHASE"}
128aa57c4b8d first try at switching postgres query to dbapiext form
Catherine Devlin <catherine.devlin@gmail.com>
parents:
diff changeset
108 ]
128aa57c4b8d first try at switching postgres query to dbapiext form
Catherine Devlin <catherine.devlin@gmail.com>
parents:
diff changeset
109 }
128aa57c4b8d first try at switching postgres query to dbapiext form
Catherine Devlin <catherine.devlin@gmail.com>
parents:
diff changeset
110
128aa57c4b8d first try at switching postgres query to dbapiext form
Catherine Devlin <catherine.devlin@gmail.com>
parents:
diff changeset
111 3 rows selected.
128aa57c4b8d first try at switching postgres query to dbapiext form
Catherine Devlin <catherine.devlin@gmail.com>
parents:
diff changeset
112
128aa57c4b8d first try at switching postgres query to dbapiext form
Catherine Devlin <catherine.devlin@gmail.com>
parents:
diff changeset
113 0:pagila@pagila> set wild on
128aa57c4b8d first try at switching postgres query to dbapiext form
Catherine Devlin <catherine.devlin@gmail.com>
parents:
diff changeset
114 wildsql - was: False
128aa57c4b8d first try at switching postgres query to dbapiext form
Catherine Devlin <catherine.devlin@gmail.com>
parents:
diff changeset
115 now: True
128aa57c4b8d first try at switching postgres query to dbapiext form
Catherine Devlin <catherine.devlin@gmail.com>
parents:
diff changeset
116 0:pagila@pagila> select #1, #2, #3 from actor;3
128aa57c4b8d first try at switching postgres query to dbapiext form
Catherine Devlin <catherine.devlin@gmail.com>
parents:
diff changeset
117
128aa57c4b8d first try at switching postgres query to dbapiext form
Catherine Devlin <catherine.devlin@gmail.com>
parents:
diff changeset
118 actor_id first_name last_name
128aa57c4b8d first try at switching postgres query to dbapiext form
Catherine Devlin <catherine.devlin@gmail.com>
parents:
diff changeset
119 -------- ---------- ---------
128aa57c4b8d first try at switching postgres query to dbapiext form
Catherine Devlin <catherine.devlin@gmail.com>
parents:
diff changeset
120 1 PENELOPE GUINESS
128aa57c4b8d first try at switching postgres query to dbapiext form
Catherine Devlin <catherine.devlin@gmail.com>
parents:
diff changeset
121 2 NICK WAHLBERG
128aa57c4b8d first try at switching postgres query to dbapiext form
Catherine Devlin <catherine.devlin@gmail.com>
parents:
diff changeset
122 3 ED CHASE
128aa57c4b8d first try at switching postgres query to dbapiext form
Catherine Devlin <catherine.devlin@gmail.com>
parents:
diff changeset
123
128aa57c4b8d first try at switching postgres query to dbapiext form
Catherine Devlin <catherine.devlin@gmail.com>
parents:
diff changeset
124 3 rows selected.
128aa57c4b8d first try at switching postgres query to dbapiext form
Catherine Devlin <catherine.devlin@gmail.com>
parents:
diff changeset
125
128aa57c4b8d first try at switching postgres query to dbapiext form
Catherine Devlin <catherine.devlin@gmail.com>
parents:
diff changeset
126 0:pagila@pagila> select !#4 from actor;3
128aa57c4b8d first try at switching postgres query to dbapiext form
Catherine Devlin <catherine.devlin@gmail.com>
parents:
diff changeset
127
128aa57c4b8d first try at switching postgres query to dbapiext form
Catherine Devlin <catherine.devlin@gmail.com>
parents:
diff changeset
128 actor_id first_name last_name
128aa57c4b8d first try at switching postgres query to dbapiext form
Catherine Devlin <catherine.devlin@gmail.com>
parents:
diff changeset
129 -------- ---------- ---------
128aa57c4b8d first try at switching postgres query to dbapiext form
Catherine Devlin <catherine.devlin@gmail.com>
parents:
diff changeset
130 1 PENELOPE GUINESS
128aa57c4b8d first try at switching postgres query to dbapiext form
Catherine Devlin <catherine.devlin@gmail.com>
parents:
diff changeset
131 2 NICK WAHLBERG
128aa57c4b8d first try at switching postgres query to dbapiext form
Catherine Devlin <catherine.devlin@gmail.com>
parents:
diff changeset
132 3 ED CHASE
128aa57c4b8d first try at switching postgres query to dbapiext form
Catherine Devlin <catherine.devlin@gmail.com>
parents:
diff changeset
133
128aa57c4b8d first try at switching postgres query to dbapiext form
Catherine Devlin <catherine.devlin@gmail.com>
parents:
diff changeset
134 3 rows selected.
128aa57c4b8d first try at switching postgres query to dbapiext form
Catherine Devlin <catherine.devlin@gmail.com>
parents:
diff changeset
135
128aa57c4b8d first try at switching postgres query to dbapiext form
Catherine Devlin <catherine.devlin@gmail.com>
parents:
diff changeset
136 0:pagila@pagila> select *name from actor;3
128aa57c4b8d first try at switching postgres query to dbapiext form
Catherine Devlin <catherine.devlin@gmail.com>
parents:
diff changeset
137
128aa57c4b8d first try at switching postgres query to dbapiext form
Catherine Devlin <catherine.devlin@gmail.com>
parents:
diff changeset
138 first_name last_name
128aa57c4b8d first try at switching postgres query to dbapiext form
Catherine Devlin <catherine.devlin@gmail.com>
parents:
diff changeset
139 ---------- ---------
128aa57c4b8d first try at switching postgres query to dbapiext form
Catherine Devlin <catherine.devlin@gmail.com>
parents:
diff changeset
140 PENELOPE GUINESS
128aa57c4b8d first try at switching postgres query to dbapiext form
Catherine Devlin <catherine.devlin@gmail.com>
parents:
diff changeset
141 NICK WAHLBERG
128aa57c4b8d first try at switching postgres query to dbapiext form
Catherine Devlin <catherine.devlin@gmail.com>
parents:
diff changeset
142 ED CHASE
128aa57c4b8d first try at switching postgres query to dbapiext form
Catherine Devlin <catherine.devlin@gmail.com>
parents:
diff changeset
143
128aa57c4b8d first try at switching postgres query to dbapiext form
Catherine Devlin <catherine.devlin@gmail.com>
parents:
diff changeset
144 3 rows selected.
128aa57c4b8d first try at switching postgres query to dbapiext form
Catherine Devlin <catherine.devlin@gmail.com>
parents:
diff changeset
145
128aa57c4b8d first try at switching postgres query to dbapiext form
Catherine Devlin <catherine.devlin@gmail.com>
parents:
diff changeset
146 0:pagila@pagila> show constraint on film_actor;
128aa57c4b8d first try at switching postgres query to dbapiext form
Catherine Devlin <catherine.devlin@gmail.com>
parents:
diff changeset
147 Constraints on BASE TABLE public.film_actor
128aa57c4b8d first try at switching postgres query to dbapiext form
Catherine Devlin <catherine.devlin@gmail.com>
parents:
diff changeset
148 Foreign key "film_actor_actor_id_fkey": columns (actor_id) in table "actor"
128aa57c4b8d first try at switching postgres query to dbapiext form
Catherine Devlin <catherine.devlin@gmail.com>
parents:
diff changeset
149 Foreign key "film_actor_film_id_fkey": columns (film_id) in table "film"
128aa57c4b8d first try at switching postgres query to dbapiext form
Catherine Devlin <catherine.devlin@gmail.com>
parents:
diff changeset
150 Primary key "film_actor_pkey": (film_id,actor_id)