pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  
help / color / mirror / Atom feed
create new table
2+ messages / 2 participants
[nested] [flat]

* create new table
@ 1999-06-22 13:32 Tamas Kohegyi <tkohegyi@gw.consultronics.hu>
  0 siblings, 0 replies; 2+ messages in thread

From: Tamas Kohegyi @ 1999-06-22 13:32 UTC (permalink / raw)
  To: pgsql-sql

Hi all,

I have to create a table in a function, but i know the name of the new
table inside the fuction only.
How can I do this? (PL/PgSQL)

e.g.:
---------------------------
DECLARE a text;
...
BEGIN
a := 'newdb';
...
CREATE TABLE a (...);
...
------------------------------

-> parse error at or near "$1"
So it does not work...

Any idea?

Thanks,
Tamas




^ permalink  raw  reply  [nested|flat] 2+ messages in thread

* create new table
@ 1999-06-22 13:33 tkohegyi@gw.cdk.bme.hu
  0 siblings, 0 replies; 2+ messages in thread

From: tkohegyi@gw.cdk.bme.hu @ 1999-06-22 13:33 UTC (permalink / raw)
  To: pgsql-sql

Hi all,

I have to create a table in a function, but i know 
the name of the new
table inside the fuction only.
How can I do this? (PL/PgSQL)

e.g.:
---------------------------
DECLARE a text;
...
BEGIN
a := 'newdb';
...
CREATE TABLE a (...);
...
------------------------------

-> parse error at or near "$1"
So it does not work...

Any idea?

Thanks,
Tamas
e-mail: tkohegyi@gw.cdk.bme.hu



| T a m a s   K o h e g y i            | H-1111 Budapest, Muegyetem rkp. 3|
| Consultronics Development Ltd.       | BME, building D. 1st floor       |
| HUNGARY                              | Tel: +36 (1) 372 0580            |
| http://www.consultronics.com         | E-mail: tkohegyi@gw.cdk.bme.hu   |



^ permalink  raw  reply  [nested|flat] 2+ messages in thread


end of thread, other threads:[~1999-06-22 13:33 UTC | newest]

Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
1999-06-22 13:32 create new table Tamas Kohegyi <tkohegyi@gw.consultronics.hu>
1999-06-22 13:33 create new table tkohegyi@gw.cdk.bme.hu

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox