Saturday, July 19, 2008

Re: [GENERAL] Whassup with this? (Create table xxx like yyy fails)


Douglas McNaught wrote:
On Sat, Jul 19, 2008 at 9:02 PM, Karl Denninger <karl@denninger.net> wrote:   
childrensjustice=# create table petition_bail like petition_white; ERROR:  syntax error at or near "like" LINE 1: create table petition_bail like petition_white;     
 It's not super-easy to see from the docs, but I think you need parentheses:  CREATE TABLE petition_bail (LIKE petition_white);  -Doug    
Aha.

Thank you.

Karl Denninger (karl@denninger.net) http://www.denninger.net

No comments: