sql - PostgreSQL: purge all tables -

-

संभव डुप्लिकेट:

डीबी में सभी तालिकाओं के सभी अभिलेखों को नष्ट करने का सबसे तेज़ तरीका क्या है, यह मानते हैं कि उनके पास बहुत अधिक डेटा नहीं है (कुछ टेबल में कुछ रिकॉर्ड हो सकते हैं लेकिन अब और नहीं)?

मुझे विश्वास है कि संरचना डंप से डेटाबेस बहुत लंबा है।

तालिका नाम 1, नाम 2, ... कास्केड

तालिकाओं के सेट से सभी पंक्तियों को जल्दी से हटा दें TRUNCATE प्रत्येक मेज पर एक अयोग्य जुर्माना के रूप में इसका एक ही प्रभाव है, लेकिन चूंकि यह वास्तव में तालिकाओं को स्कैन नहीं करता है, यह तेज़ है यह बड़े तालिकाओं पर सबसे अधिक उपयोगी है।

यदि आपके पास बहुत सी तालिकाओं हैं, तो आप तालिकाओं की सूची के लिए क्वेरी जान सकते हैं और गतिशील रूप से त्रिकोण क्वेरी का निर्माण कर सकते हैं, लेकिन थोड़ी सी तालिकाओं के लिए आप केवल नामों को हाथ से लिख सकते हैं।

सभी तालिकाओं को चुनने और एक क्वेरी को गतिशील रूप से चलाने पर जानकारी के लिए देखें दिया गया उदाहरण grantall के लिए है लेकिन विचार समान है।


Comments

Post a Comment

Popular posts from this blog

Indexing in SQL -

-
My table has 10 columns .... What column do I choose to create an index? Is there a guideline rule to do this? What are the disadvantages of indexes? What if I update the column which is part of the index? Does this reduce performance of INDEXES? from other posts: 1.1 You should make indexes on columns that are often used in the WHERE section. 1.2 You should be indexed on the columns you use repeatedly to come into the columns. 1.3 You should make indexes on columns that are often used 1.4 You get indexed on the columns The table should contain some of the same values ​​or unique values. 1.5 You should not index small tables (tables using only a few blocks) because a full table scan can be faster than the indexed query. 1.6 If more than one column is often used in the WHERE section in a converged index, then first create the most selected columns, pre-create in the index statement. 1.7 column has many nulls and you do not search for zero-value v...
Read more

objective c - iPhone and it's wireless area -

-
Is this a way to find other iPhones in the category of wireless areas? So I give an example. I'm staying at the airport somewhere I have an iPhone too. I and the other iPhone owners are playing the same game. Is there any way to warn me and the other player that we are close to each other? Does this work even if we are not on the same wireless network, or there is no wireless? And if there is any way to do this, can you give me some starting point? Like a link where I can learn something like this or maybe this is probably the name of this process, because I do not know how to search about this topic in Google. Thanks in advance! Can be completed with peer-to-peer discovery and connectivity you are describing Game Kit Framework Originally I thought it works only through Bluetooth, but after watching it immediately, it seems that WiFi is also supported. Hope it helps!
Read more

multithreading - Do lock objects in Java need to be static? -

-
I know in C # when you have an object that you want to use as a lock for multi-threading You must declare it stable inside a class, which class instances will be running in different threads. Is this also true for Java? Some examples online only begin declaring the last object as a lock object ... EDIT: I have a resource that I want to limit to only one thread access at a time. A class that extends the thread will be used to create many instances and will start at the same time. Thanks Depending on which context they are used they will be used. If you want a per-instance lock, go away still . If you want a per-class lock, use still in addition to actually put it the last .
Read more