Red Hat Database Extensions to the JDBC API

package org.postgresql.fastpath;
   public class Fastpath {
      // Methods
      public void addFunction(String name, int fnid);
      public void addFunctions(ResultSet rs) throws SQLException;
      public Object fastpath(int field, boolean resulttype, 
         FastpathArg args[]) throws SQLException;
      public Object fastpath(String name, boolean resulttype, 
         FastpathArg args[]) throws SQLException;
      public byte[] getData(String name, FastpathArg args[]) throws SQLException;
      public int getID(String name) throws SQLException;
      public int getInteger(String name, FastpathArg args[]) throws SQLException;
   }

package org.postgresql.fastpath;
public class FastpathArg {
   public FastpathArg(int value);
   public FastpathArg(byte[] bytes);
   public FastpathArg(byte[] buf, int off, int len);
   public FastpathArg(String s);
}

package org.postgresql.largeobject;
public class LargeObject {
   // Constants
   public static final int SEEK_SET;
   public static final int SEEK_CUR;
   public static final int SEEK_END;
   
   // Methods
   public void close() throws SQLException;
   public int getOID();
   public byte[] read(int len) throws SQLException;
   public void read(byte buf[], int off, int len) 
      throws SQLException;
   public void write(byte buf[]) throws SQLException;
   public void write(byte buf[], int off, int len) 
      throws SQLException;
}

import org.postgresql.Connection;
import org.postgresql.largeobject.*;

Connection con;
LargeObjectManager lobj;
// ... code that opens a connection ...
lobj = ((org.postgresql.Connection) 
   con).getLargeObjectAPI();

package org.postgresql.largeobject;
public class LargeObjectManager {
   // Constants
   public static final int WRITE;
   public static final int READ;
   public static final int READWRITE;
   
   // Methods
   public LargeObject open(int oid) throws SQLException;
   public LargeObject open(int oid, int mode) throws SQLException;
   public int create() throws SQLException;
   public int create(int mode) throws SQLException;
   public void delete(int oid) throws SQLException;
   public void unlink(int oid) throws SQLException;
}

test=> create table users (username name,fullname text);
CREATE
test=> create table server (servername name,adminuser users);
CREATE
test=> insert into users values ('peter','Peter Mount');
INSERT 2610132 1
test=> insert into server values ('maidast',2610132::users);
INSERT 2610133 1
test=> select * from users;
username|fullname      
--------+--------------
peter   |Peter Mount   
(1 row)

test=> select * from server;
servername|adminuser
----------+---------
maidast   |  2610132
(1 row)

public int oid;

package org.postgresql.util;
public class PGobject implements Serializable, Cloneable {
   // Constructors
   public PGobject();
   
   // Methods
   public Object clone();
   public boolean equals(Object obj);
   public final String getType();
   public String getValue();
   public final void setType(String type);
   public void setValue(String value) throws SQLException;
   public String toString();
}

package org.postgresql.util;
public class PGmoney extends PGobject 
   implements Serializable, Cloneable {
   // Variables
   public double val;
   
   // Constructors
   public PGmoney();
   public PGmoney(double val);
   public PGmoney(String value) throws SQLException;
   
   // Methods
   public void setValue(String s) throws SQLException;
   public boolean equals(Object obj);
   public Object clone();
   public String getValue();
}

package org.postgresql.util;
public class PGtokenizer {
   // Constructors
   public PGtokenizer(String string, char delim);
   
   // Methods
   public int getSize();
   public String getToken(int n);
   public void remove(String l, String t);
   public void removeAngle();
   public void removeBox();
   public void removePara();
   public int tokenize(String string, char delim);
   public PGtokenizer tokenizeToken(int n, char delim);
   
   // Class methods
   public static String remove(String s, String l, String t);
   public static String removeAngle(String s);
   public static String removeBox(String s);
   public static String removePara(String s);
}

package org.postgresql.util;
public class UnixCrypt {
   // Class Methods
   public static final String crypt(String original);
   public static final String crypt(String salt, 
      String original);
   public static final boolean matches(String 
      encrypted, String entered);
}

package org.postgresql.geometric;
public class PGpoint extends PGobject 
   implements Serializable, Cloneable {
   // Variables
   public double x;
   public double y;
   
   // Constructors
   public PGpoint();
   public PGpoint(double x, double y);
   public PGpoint(String value) throws SQLException;
   
   // Methods
   public Object clone();
   public boolean equals(Object obj);
   public String getValue();
   public void move(int x, int y);
   public void move(double x, double y);
   public void setLocation(int x, int y);
   public void setLocation(Point p);
   public void setValue(String s) throws SQLException;
   public void translate(int x, int y);
   public void translate(double x, double y);
}

package org.postgresql.geometric;
public class PGlseg extends PGobject 
   implements Serializable, Cloneable {
   // Variables
   public PGpoint[] point;
   
   // Constructors
   public PGlseg();
   public PGlseg(double x1, double y1, double x2, double y2);
   public PGlseg(PGpoint p1, PGpoint p2);
   public PGlseg(String s) throws SQLException;
   
   // Methods
   public Object clone();
   public boolean equals(Object obj);
   public String getValue();
   public void setValue(String s) throws SQLException;
}

package org.postgresql.geometric;
public class PGline extends PGobject 
   implements Serializable, Cloneable {
   // Variables
   public PGpoint[] point;
   
   // Constructors
   public PGline();
   public PGline(double x1, double y1, double x2, double y2);
   public PGline(PGpoint p1, PGpoint p2);
   public PGline(String s) throws SQLException;
   
   // Methods
   public Object clone();
   public boolean equals(Object obj);
   public String getValue();
   public void setValue(String s) throws SQLException;
}

package org.postgresql.geometric;
public class PGbox extends PGobject 
   implements Serializable, Cloneable {
   // Variables
   public PGpoint[] point;
   
   // Constructors
   public PGbox(double x1, double y1, double x2, double y2);
   
   // Methods
   public Object clone();
   public boolean equals(Object obj);
   public String getValue();
         	public void setValue(String value) throws SQLException;
}

package org.postgresql.geometric;
public class PGpolygon extends PGobject 
   implements Serializable, Cloneable {
   // Variables
   public PGpoint[] points;
   
   // Constructors
   public PGpolygon();
   public PGpolygon(PGpoint points[]);
   public PGpolygon(String s) throws SQLException;
   
   // Methods
   public Object clone();
   public boolean equals(Object obj);
   public String getValue();
   public void setValue(String s) throws SQLException;
}

package org.postgresql.geometric;
public class PGcircle extends PGobject implements 
   Serializable, Cloneable {
   // Variables
   public PGpoint center;
   public double radius;
   
   // Constructors
   public PGcircle();
   public PGcircle(double x, double y, double r);
   public PGcircle(PGpoint c, double r);
   public PGcircle(String s) throws SQLException;
   
   // Methods
   public Object clone();
   public boolean equals(Object obj);
   public String getValue();
   public void setValue(String s) throws SQLException;
}

package org.postgresql.geometric;
public class PGpath extends PGobject implements 
   Serializable, Cloneable {
   // Variables
   public boolean open;
   public PGpoint[] points;
   
   // Constructors
   public PGpath();
   public PGpath(PGpoint points[], boolean open);
   public PGpath(String s) throws SQLException;
   
   // Methods
   public Object clone();
   public void closePath();
   public boolean equals(Object obj);
   public String getValue();
   public boolean isClosed();
   public boolean isOpen();
   public void openPath();
   public void setValue(String s) throws SQLException;
}