Creating table columns from ???

Поиск
Список
Период
Сортировка
От Chadwick Rolfs
Тема Creating table columns from ???
Дата
Msg-id Pine.LNX.4.33.0106021511390.13197-100000@webdevel.urban.csuohio.edu
обсуждение исходный текст
Ответы Re: Creating table columns from ???
Список pgsql-novice
That is, anything but by hand...
It seems that there is a missing function that would be very obvious and
one of the first things available:
  here's what I want to do:
    create table form_two ( <file with names and values> );
  or even better, from perl, or php (I am now using Pg.pm)
    create table form_two ( %hash_with_names_and_values );

How easy does this look?  It seems that this would be though of already,
but the only way I see to make tables is this way...:

create table page_one (
    spacer    text null,
    name    text,
    street    text,
    city    text,
    state    text,
    zip    integer,
    length    integer,
    yorm    text,
    phone    text,
    opt    text,
    fax    text,
    email    text,
    ceo    text,
    senior    text,
    comp    text,
    d_o_c    date,
    webPG    text,
    n_o_b    text,
    pge    integer,
    spacer2    text null
);
(doesn't this seem a bit cumbersome?)

And this is the smallest out of eleven forms (a small web site indeed.)
So what do all those people do with huge sites, and bigger forms?  There
must be something I'm missing.  Please, someone point it out to me, as
this project goes to the funders june 8.
I appreciate everyone's help in all matters, thank you.

Chadwick Rolfs


В списке pgsql-novice по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: PG_DUMP fails to load back in
Следующее
От: "Mohammed A"
Дата:
Сообщение: monitoring