SQL ¿¹Á¦·Î ¹è¿ì´Â PostgreSQL (ver 0.91a)

ÁÖÈ¿½Ä nogadax@kldp.org

1. µé¾î°¡¸ç

• 1.1 Å×½ºÆ® ȯ°æ
• 1.2 ÂüÁ¶ »çÀÌÆ®
• 1.3 ´çºÎÀÇ ¸»

2. ¼³Ä¡ ¹× ±âŸ»çÇ×

• 2.1 Source Install
• 2.2 initdb
• 2.3 initlocation ¿¹Á¦
• 2.4 template1
• 2.5 pg_ctl
• 2.6 pg_hba.conf

3. ±âÃÊÆí 1

• 3.1 ¹®ÀÚ¿­ »ó¼ö (String Constants)
• 3.2 Integer Constants
• 3.3 Floating Point Constants
• 3.4 Data Types
• 3.5 Function Constants
• 3.6 String Functions
• 3.7 SQL FUNCTIONs
• 3.8 SQL FUNCTIONÀ» ÀÌ¿ëÇÑ ÇÔ¼ö ¿¹Á¦
• 3.9 Full SQL SOURCE

4. ±âÃÊÆí 2

• 4.1 īƼÁ¯ °ö (cartesian product)
• 4.2 ÇÕÁýÇÕ (UNION)
• 4.3 Â÷ÁýÇÕ (EXCEPT)
• 4.4 ±³ÁýÇÕ (INTERSECT)
• 4.5 Sub_query
• 4.6 Aggregate Function
• 4.7 group by, having
• 4.8 JOIN and VIEW
• 4.9 "LIKE" AND "order by"
• 4.10 Like,  ,  * ¿¹Á¦

5. Áß±ÞÆí

• 5.1 primary,foreign key ¿¹Á¦ 1
• 5.2 primary,foreign key ¿¹Á¦ 2
• 5.3 serial,sequence
• 5.4 Function
• 5.5 PL/pgSQL
• 5.6 Æ®¸®°Å ÇÁ·Î½ÃÁ®
• 5.7 Æ®¸®°Å
• 5.8 Rule examples
• 5.9 ½Ã½ºÅÛ Ä«Å»·Î±× È°¿ë ¿¹
• 5.10 pg_shadow,pg_user