droptableifexiststable;createtabletable(
id SERIAL PRIMARYKEY,
gmt_create timestamp without timezone,
gmt_modified timestamp without timezone,
baseInfo json
);
搜索语句
select baseInfo fromtable
异常
ERROR: column "baseinfo" does not exist
LINE 1: select baseInfo from table
<script type="text/javascript"> $(function () { $('pre.prettyprint code').each(function () { var lines = $(this).text().split('\n').length; var $numbering = $('<ul/>').addClass('pre-numbering').hide(); $(this).addClass('has-numbering').parent().append($numbering); for (i = 1; i <= lines; i++) { $numbering.append($('<li/>').text(i)); }; $numbering.fadeIn(1700); }); }); </script>
建表语句drop table if exists table;create table table( id SERIAL PRIMARY KEY, gmt_create timestamp without time zone, gmt_modified timestamp without time zone, baseInfo json);...