背景:我试图将INSERT数据列入分门表。 我的表格分数了几个月,因为我的数据很多(预计会增加数量),最近的数据更经常被问。 任何关于分治选择的评论都值得欢迎(但回答我的问题将受到欢迎)。
我真的不喜欢这一解决办法。 我想说的是,什么将完美地工作,我赢得了现在和现在都需要更新,这将超出我和我的孙辈。
So I was wondering if I could make a trigger that would look like this:
INSERT INTO get_the_appropriate_table_name(NEW.date) VALUES (NEW.*);
不幸的是,我的一切努力都失败了。 我用“reg子”进行尝试,但没有成功。
简言之,我要作一个插图,把它当作一个表名。 这是可能的吗?
I was just about to write a trigger function using EXECUTE to insert into a table according to the date_parts of now(), or create it first if it should not exist .. when I found that somebody had already done that for us - right under the chapter of the docs you are referring to yourself:
http://www.postgresql.org/docs/9.0/interactive/ddl-partitioning.html
将所有途径放到用户“用户评论”。 Laban Mwangi树立了一个榜样。
《邮政手册》的/interactive分行已经删除,链接被重新定位。 因此,我所说的话已经过去。 查阅这些后来与详细指示密切相关的答复:
关于
我如何将Excel板的数据输入我的Django应用? I m将PosgreSQL数据库作为数据库。
On production our database is a few hundred gigabytes in size. For development and testing, we need to create snapshots of this database that are functionally equivalent, but which are only 10 or 20 ...
I ll take the simplest of the SQL functions as an example: CREATE OR REPLACE FUNCTION skater_name_match(INTEGER,VARCHAR) RETURNS BOOL AS $$ SELECT $1 IN (SELECT skaters_skater.competitor_ptr_id ...
I m 在当地网络上运行几台机器,在Salgresql8.3处撰写一份申请。
I want to join few attributes in select statement as one for example select id, (name + + surname + + age) as info from users this doesn t work, how to do it? I m using postgreSQL.
Hey, I have 2 tables in PostgreSql: 1 - documents: id, title 2 - updates: id, document_id, date and some data: documents: | 1 | Test Title | updates: | 1 | 1 | 2006-01-01 | | 2 | 1 | 2007-01-01 |...
I need to setup my PostgreSQL DB s text encoding to handle non-American English characters that you d find showing up in languages such as German, Spanish, and French. What character encoding should ...
I am using a set of SQL LIKE conditions to go through the alphabet and list all items beginning with the appropriate letter, e.g. to get all books where the title starts with the letter "A": SELECT * ...