{"action":"created","issue":{"url":"https://api.github.com/repos/begriffs/postgrest/issues/413","labels_url":"https://api.github.com/repos/begriffs/postgrest/issues/413/labels{/name}","comments_url":"https://api.github.com/repos/begriffs/postgrest/issues/413/comments","events_url":"https://api.github.com/repos/begriffs/postgrest/issues/413/events","html_url":"https://github.com/begriffs/postgrest/issues/413","id":121118935,"number":413,"title":"Question regarding embedding foreign entities","user":{"login":"matias-piin","id":15108415,"avatar_url":"https://avatars.githubusercontent.com/u/15108415?v=3","gravatar_id":"","url":"https://api.github.com/users/matias-piin","html_url":"https://github.com/matias-piin","followers_url":"https://api.github.com/users/matias-piin/followers","following_url":"https://api.github.com/users/matias-piin/following{/other_user}","gists_url":"https://api.github.com/users/matias-piin/gists{/gist_id}","starred_url":"https://api.github.com/users/matias-piin/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/matias-piin/subscriptions","organizations_url":"https://api.github.com/users/matias-piin/orgs","repos_url":"https://api.github.com/users/matias-piin/repos","events_url":"https://api.github.com/users/matias-piin/events{/privacy}","received_events_url":"https://api.github.com/users/matias-piin/received_events","type":"User","site_admin":false},"labels":[],"state":"closed","locked":false,"assignee":null,"milestone":null,"comments":15,"created_at":"2015-12-08T22:51:45Z","updated_at":"2015-12-29T18:02:15Z","closed_at":"2015-12-09T20:50:52Z","body":"Hi,\r\n\r\nI've been running into a problem regarding the topic 'Embedding Foreign Entities'.\r\n\r\nI have the following schema:\r\n\r\nauthor\r\n-author_id\r\n-name\r\n\r\nbook\r\n-book_id\r\n-name\r\n-author_id (FK)\r\n\r\nand I'm trying to write a query that for a given author will return the author info and all of the books they've written.\r\n\r\nI try the following and get an error:\r\n`localhost:3000/author?author_id=eq.1&select=name,book{*}`\r\nreturns\r\n`{\"hint\":null,\"details\":null,\"code\":\"42703\",\"message\":\"column author.book does not exist\"}%`\r\n\r\nif I try \r\n`localhost:3000/book?book_id=eq.1&select=name,author{*}`\r\nit returns\r\n`{\"hint\":null,\"details\":null,\"code\":\"42703\",\"message\":\"column book.author does not exist\"}%`\r\n\r\nI have also tried\r\n`localhost:3000/book?book_id=eq.1&select=name,author_id{*}`\r\nbut it just returns\r\n`[{\"book_id\":1,\"author_id\":1}]%`\r\n\r\nI thought this would be possible from reading the [documentation](http://postgrest.com/api/reading/#embedding-foreign-entities), but I'm not sure if I'm mis-understanding that doc or just applying it the wrong way. Any help or tips would be greatly appreciated :) Sorry if this is not the best place to ask this question.\r\n\r\nThank you!"},"comment":{"url":"https://api.github.com/repos/begriffs/postgrest/issues/comments/167844711","html_url":"https://github.com/begriffs/postgrest/issues/413#issuecomment-167844711","issue_url":"https://api.github.com/repos/begriffs/postgrest/issues/413","id":167844711,"user":{"login":"WillForan","id":680742,"avatar_url":"https://avatars.githubusercontent.com/u/680742?v=3","gravatar_id":"","url":"https://api.github.com/users/WillForan","html_url":"https://github.com/WillForan","followers_url":"https://api.github.com/users/WillForan/followers","following_url":"https://api.github.com/users/WillForan/following{/other_user}","gists_url":"https://api.github.com/users/WillForan/gists{/gist_id}","starred_url":"https://api.github.com/users/WillForan/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/WillForan/subscriptions","organizations_url":"https://api.github.com/users/WillForan/orgs","repos_url":"https://api.github.com/users/WillForan/repos","events_url":"https://api.github.com/users/WillForan/events{/privacy}","received_events_url":"https://api.github.com/users/WillForan/received_events","type":"User","site_admin":false},"created_at":"2015-12-29T18:02:15Z","updated_at":"2015-12-29T18:02:15Z","body":"Hit the same issue with curl. This issue me a few more hours of head pounding. Here's my revised and working call to curl with `data-urlencode`\r\n\r\n```\r\ncurl 'localhost:3001/enroll' \\\r\n  -G --data-urlencode 'id=like.10931' \\\r\n  -G --data-urlencode 'select=id,person{*}'  | jq\r\n```"}}