Main.PostgresqlNotes History
Hide minor edits - Show changes to output
2007-03-22，05:24 下午
by -
Changed line 7 from:
to
\\
Added line 11:
\\
2007-03-22，04:20 下午
by -
Changed line 10 from:
** @@SELECT table_catalog FROM information_schema.tables WHERE table_schema = 'public' GROUP BY table_catalog;@@ %green%'''/* Will display all table_catalogs but the same will appear once only */'''%%
to
** @@SELECT table_catalog FROM information_schema.tables WHERE table_schema = 'public' GROUP BY table_catalog;@@ %green%'''/* Will display all table_catalogs but the sames will appear once only */'''%%
2007-03-22，04:19 下午
by -
Changed line 5 from:
*** [[ http://www.postgresql.org/docs/8.0/interactive/tutorial-accessdb.html | The user comment on the postgre document page ]]
to
*** [[ http://www.postgresql.org/docs/8.0/interactive/tutorial-accessdb.html | The user comment on the postgresql document page ]]
Changed line 10 from:
** @@SELECT table_catalog FROM information_schema.tables WHERE table_schema = 'public' GROUP BY table_catalog;@@
to
** @@SELECT table_catalog FROM information_schema.tables WHERE table_schema = 'public' GROUP BY table_catalog;@@ %green%'''/* Will display all table_catalogs but the same will appear once only */'''%%
2007-03-22，04:18 下午
by -
Changed line 13 from:
** @@SELECT table_name FROM information_schema.tables WHERE table_schema = 'public' AND table_name LIKE 'm%';@@ '''/* Will display all tables whose table_name starts with m*/'''
to
** @@SELECT table_name FROM information_schema.tables WHERE table_schema = 'public' AND table_name LIKE 'm%';@@ %green%'''/* Will display all tables whose table_name starts with m*/'''%%
2007-03-22，04:17 下午
by -
Changed lines 13-14 from:
** @@SELECT table_name FROM information_schema.tables WHERE table_schema = 'public' AND table_name LIKE 'm%';@@
*
*
to
** @@SELECT table_name FROM information_schema.tables WHERE table_schema = 'public' AND table_name LIKE 'm%';@@ '''/* Will display all tables whose table_name starts with m*/'''
2007-03-22，04:15 下午
by -
Changed lines 2-6 from:
** 如果是用 psql 連到 database 中的話可以使用 @@\dt@@ 這個指令來看.
** 或是直接使用 SQL 語法來查詢: @@SELECT table_name FROM information_schema.tables WHERE table_schema = 'public';@@
** Reference:
*** [[ http://www.postgresql.org/docs/8.0/interactive/tutorial-accessdb.html | The user comment on the postgre document page ]]
*** [[ http://www.tech-recipes.com/modules.php?name=Forums&file=viewtopic&t=1052#3761 | Display or show tables in a PostgreSQL/PgSQL database on tech-recipes ]]
** 或是直接使用 SQL 語法來查詢: @@SELECT table_name FROM information_schema.tables WHERE table_schema = 'public';@@
** Reference:
*** [[ http://www.postgresql.org/docs/8.0/interactive/tutorial-accessdb.html | The user comment on the postgre document page ]]
*** [[ http://www.tech-recipes.com/modules.php?name=Forums&file=viewtopic&t=1052#3761 | Display or show tables in a PostgreSQL/PgSQL database on tech-recipes ]]
to
** 如果是用 psql 連到 database 中的話可以使用 @@\dt@@ 這個指令來看.
** 或是直接使用 SQL 語法來查詢: @@SELECT table_name FROM information_schema.tables WHERE table_schema = 'public';@@
** Reference:
*** [[ http://www.postgresql.org/docs/8.0/interactive/tutorial-accessdb.html | The user comment on the postgre document page ]]
*** [[ http://www.tech-recipes.com/modules.php?name=Forums&file=viewtopic&t=1052#3761 | Display or show tables in a PostgreSQL/PgSQL database on tech-recipes ]]
* GROUP BY
** @@SELECT@@ ''column_name'' @@FROM@@ ''table_name'' @@GROUP BY@@ ''column_name'' @@;@@
** @@SELECT table_catalog FROM information_schema.tables WHERE table_schema = 'public' GROUP BY table_catalog;@@
* LIKE
** @@SELECT * FROM@@ ''table_name'' @@WHERE@@ ''string'' @@LIKE@@ ''pattern'' @@;@@
** @@SELECT table_name FROM information_schema.tables WHERE table_schema = 'public' AND table_name LIKE 'm%';@@
*
** 或是直接使用 SQL 語法來查詢: @@SELECT table_name FROM information_schema.tables WHERE table_schema = 'public';@@
** Reference:
*** [[ http://www.postgresql.org/docs/8.0/interactive/tutorial-accessdb.html | The user comment on the postgre document page ]]
*** [[ http://www.tech-recipes.com/modules.php?name=Forums&file=viewtopic&t=1052#3761 | Display or show tables in a PostgreSQL/PgSQL database on tech-recipes ]]
* GROUP BY
** @@SELECT@@ ''column_name'' @@FROM@@ ''table_name'' @@GROUP BY@@ ''column_name'' @@;@@
** @@SELECT table_catalog FROM information_schema.tables WHERE table_schema = 'public' GROUP BY table_catalog;@@
* LIKE
** @@SELECT * FROM@@ ''table_name'' @@WHERE@@ ''string'' @@LIKE@@ ''pattern'' @@;@@
** @@SELECT table_name FROM information_schema.tables WHERE table_schema = 'public' AND table_name LIKE 'm%';@@
*
2006-11-02，04:06 下午
by -
Added lines 1-6:
* 在 mysql 中可以用 @@SHOW TABLES@@ 來查看目前database中有那些 tables, 而在 PostgreSQL 中, 有兩種方法:
** 如果是用 psql 連到 database 中的話可以使用 @@\dt@@ 這個指令來看.
** 或是直接使用 SQL 語法來查詢: @@SELECT table_name FROM information_schema.tables WHERE table_schema = 'public';@@
** Reference:
*** [[ http://www.postgresql.org/docs/8.0/interactive/tutorial-accessdb.html | The user comment on the postgre document page ]]
*** [[ http://www.tech-recipes.com/modules.php?name=Forums&file=viewtopic&t=1052#3761 | Display or show tables in a PostgreSQL/PgSQL database on tech-recipes ]]
** 如果是用 psql 連到 database 中的話可以使用 @@\dt@@ 這個指令來看.
** 或是直接使用 SQL 語法來查詢: @@SELECT table_name FROM information_schema.tables WHERE table_schema = 'public';@@
** Reference:
*** [[ http://www.postgresql.org/docs/8.0/interactive/tutorial-accessdb.html | The user comment on the postgre document page ]]
*** [[ http://www.tech-recipes.com/modules.php?name=Forums&file=viewtopic&t=1052#3761 | Display or show tables in a PostgreSQL/PgSQL database on tech-recipes ]]