SQL Plugin copied from Quantum plugin and refactored for PHPEclipse

[phpeclipse.git] / archive / net.sourceforge.phpeclipse.sql / src / net / sourceforge / phpdt / sql / adapters / PostgresAdapter.java

diff --git a/archive/net.sourceforge.phpeclipse.sql/src/net/sourceforge/phpdt/sql/adapters/PostgresAdapter.java b/archive/net.sourceforge.phpeclipse.sql/src/net/sourceforge/phpdt/sql/adapters/PostgresAdapter.java
new file mode 100644 (file)
index 0000000..3f07015
--- /dev/null
+++ b/archive/net.sourceforge.phpeclipse.sql/src/net/sourceforge/phpdt/sql/adapters/PostgresAdapter.java
@@ -0,0 +1,23 @@
+package net.sourceforge.phpdt.sql.adapters;
+
+
+public class PostgresAdapter extends DatabaseAdapter {
+    public String getShowTableQuery(DatabaseInfo info) {
+        return "SELECT TABLENAME FROM PG_TABLES";
+    }
+    public String getShowViewQuery(DatabaseInfo info) {
+        return "SELECT VIEWNAME FROM PG_VIEWS";
+    }
+    public String getShowSequenceQuery(DatabaseInfo info) {
+        return "SELECT relname FROM pg_class WHERE relkind = 'S'";
+    }
+    public String getNextValue(String sequence) {
+        return "select nextval('" + sequence + "')";
+    }
+    public String getTableListFilter() {
+        return "pg_";
+    }
+       public DatabaseAdapter getInstance() {
+               return new PostgresAdapter();
+       }
+}
\ No newline at end of file