postgres:copy_command
Differences
This shows you the differences between two versions of the page.
| Both sides previous revision Previous revision Next revision | Previous revision | ||
|
postgres:copy_command [2013/07/26 20:31] mh |
postgres:copy_command [2014/09/10 21:22] (current) |
||
|---|---|---|---|
| Line 22: | Line 22: | ||
| world-# select code, (select id from organisations where name = 'EU') from countries where name in (select state from membership_raw where eu = 'EU'); | world-# select code, (select id from organisations where name = 'EU') from countries where name in (select state from membership_raw where eu = 'EU'); | ||
| + | |||
| + | world=# select c.name, o.name from countries c join countries_x_organisations cxo | ||
| + | on cxo.code = c.code join organisations o on o.id = cxo.organisation_id; | ||
| + | |||
| + | </code> | ||
postgres/copy_command.1374863508.txt.gz ยท Last modified: 2014/09/10 21:22 (external edit)
Page Tools
Except where otherwise noted, content on this wiki is licensed under the following license: CC Attribution-Share Alike 4.0 International
