Hi list,
I try to create a table using plpgsql or plpythonu. I'm starting with
programming in postgresql therfore I'm a little bit confused. I know a
little bit of python and a little bit of SQL. May be some hints could
help me gettin into it:
My problem is:
I'm having a table with a column a and certain values in it.
_a_|_b_
ab | v1
de | v2
fc | v3
wd | v4
ed | v5
...|...
And I need a script to make the first column the rownames and the other
columns the values of the newly created table:
CREATE TABLE test(
ID BIGINT,
ab TEXT,
de TEXT,
fc TEXT,
wd TEXT,
ed TEXT,
...
PRIMARY KEY(ID));
and: INSERT INTO test VALUES('v1', 'v2', 'v3', 'v4', 'v5', ...);
The number of rows and the names of the columns vary.
I get a list of the values in the first table by SELECT a FROM table1;
But how to put this into a CREATE TABLE script - and fill in the other
columns as values?
Marco
begin:vcard
fn:Marco Lechner
n:Lechner;Marco
org;quoted-printable:Uni Freiburg;Institut f=C3=BCr Physische Geographie
adr:;;Werthmannstr. 4;Freiburg;;79085;Deutschland
email;internet:marco.lech...@geographie.uni-freiburg.de
tel;work:+49 (0)761/203-3548
tel;fax:+49 (0)761/203-3596
x-mozilla-html:FALSE
version:2.1
end:vcard
--
Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-sql
