<p>Looks like <a href="https://www.postgresql.org/docs/current/sql-syntax-lexical.html#SQL-SYNTAX-IDENTIFIERS" rel="nofollow">postgres allows everything except NUL in column names</a>.</p>
<pre><code>SELECT 'pipe' AS "|", 'backtick' AS "`", 'backslash' AS "\", 'TAB' AS U&amp;"\0009"; -- ok
SELECT 'NUL' AS U&amp;"\0000"; -- fails
</code></pre>

<p style="font-size:small;-webkit-text-size-adjust:none;color:#666;">&mdash;<br />You are receiving this because you are subscribed to this thread.<br />Reply to this email directly, <a href="https://github.com/Perl5/DBIx-Class/pull/129#issuecomment-451101440">view it on GitHub</a>, or <a href="https://github.com/notifications/unsubscribe-auth/AASeAuVODsjvEqpXsqqfkYNP1ow7_3wWks5u_dcLgaJpZM4XZ4rx">mute the thread</a>.<img src="https://github.com/notifications/beacon/AASeAgkJgkx3wt8yu0D5Yk23DcmR06qlks5u_dcLgaJpZM4XZ4rx.gif" height="1" width="1" alt="" /></p>
<script type="application/json" data-scope="inboxmarkup">{"api_version":"1.0","publisher":{"api_key":"05dde50f1d1a384dd78767c55493e4bb","name":"GitHub"},"entity":{"external_key":"github/Perl5/DBIx-Class","title":"Perl5/DBIx-Class","subtitle":"GitHub repository","main_image_url":"https://github.githubassets.com/images/email/message_cards/header.png","avatar_image_url":"https://github.githubassets.com/images/email/message_cards/avatar.png","action":{"name":"Open in GitHub","url":"https://github.com/Perl5/DBIx-Class"}},"updates":{"snippets":[{"icon":"PERSON","message":"@pdl in #129: Looks like [postgres allows everything except NUL in column names](https://www.postgresql.org/docs/current/sql-syntax-lexical.html#SQL-SYNTAX-IDENTIFIERS). \r\n\r\n```\r\nSELECT 'pipe' AS \"|\", 'backtick' AS \"`\", 'backslash' AS \"\\\", 'TAB' AS U\u0026\"\\0009\"; -- ok\r\nSELECT 'NUL' AS U\u0026\"\\0000\"; -- fails\r\n```"}],"action":{"name":"View Pull Request","url":"https://github.com/Perl5/DBIx-Class/pull/129#issuecomment-451101440"}}}</script>
<script type="application/ld+json">[
{
"@context": "http://schema.org",
"@type": "EmailMessage",
"potentialAction": {
"@type": "ViewAction",
"target": "https://github.com/Perl5/DBIx-Class/pull/129#issuecomment-451101440",
"url": "https://github.com/Perl5/DBIx-Class/pull/129#issuecomment-451101440",
"name": "View Pull Request"
},
"description": "View this Pull Request on GitHub",
"publisher": {
"@type": "Organization",
"name": "GitHub",
"url": "https://github.com"
}
}
]</script>