select open change scope Open full search

PG.CENTER connects PostgreSQL documentation, reference, and ecosystem knowledge. Maintained by Pigsty.

Unsupported versions: 7.4 / 7.3 / 7.2
Historical version. PostgreSQL 7.3 reached end of support in November 2007. See the current manual for supported releases.

5.5. Creating and Modifying Database Objects

To create, modify or drop a database object like a table or view you use the execute() method. execute is similar to the executeQuery() used to issue a select, however it doesn't return a result.

Example 5-3. Drop Table Example

This example will drop a table.

Statement st = db.createStatement();
ResultSet rs = st.executeQuery("DROP TABLE mytable");
st.close();

Report a documentation issue

Read the upstream documentation. For corrections, first check the current manual.