Re: [HACKERS] Idea about sql command create table like

2008-03-12 Thread Euler Taveira de Oliveira
David BOURIAUD wrote: Could it be possible to have a syntax that would allow to use create table like to rename fields as well, for example : create table any_lib like (some_lib including constraints) with names (any_code, any_text); What about coding a replace-stuff-function in pl/* ?

[HACKERS] Idea about sql command create table like

2008-03-11 Thread David BOURIAUD
Hello, I've seen that postgreSQL tries to follow sql standards as far as possible, and that sometimes (often) brings it's own extentions. I've thought of one concerning the sql command create table like. As far as I've understood the documentation, one can create a table using another table as