From: | Jeff Eckermann <jeff_eckermann(at)yahoo(dot)com> |
---|---|
To: | Yovko Ilchev Yovkov <yyovkov(at)vipsolutions(dot)net>, pgsql-novice(at)postgresql(dot)org |
Subject: | Re: Insert on create table |
Date: | 2003-05-16 20:12:01 |
Message-ID: | 20030516201201.98175.qmail@web20806.mail.yahoo.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-novice |
--- Yovko Ilchev Yovkov <yyovkov(at)vipsolutions(dot)net>
wrote:
> Can anyone tell what I am in need of to do smthng
> like:
> When: CREATE TABLE table_1 (...);
> Automaticaly to execute: INSERT INTO TABLE newtables
> (name) VALUE (table_1);
Not with ordinary SQL. Two choices:
1. Code this into your application.
2. Write a function to create tables, which includes
the insert. Then use only that function when creating
your tables. But you will still need to restrict
access to your application only, as any user who can
connect directly to the database will be able to
create tables directly. I would prefer solution 1.
__________________________________
Do you Yahoo!?
The New Yahoo! Search - Faster. Easier. Bingo.
http://search.yahoo.com
From | Date | Subject | |
---|---|---|---|
Next Message | Nabil Sayegh | 2003-05-16 20:56:45 | Re: Insert on create table |
Previous Message | Jeff Eckermann | 2003-05-16 20:04:16 | Re: Copy command (bug??) |