How do I execute \d tablename using Java and PostgreSQL?
PreparedStatement pst = jdbc.conn.prepareStatement("\d u_item");
ResultSet set = pst.executeQuery();
Error:
org.postgresql.util.PSQLException: ERROR: syntax error at or near "\"
2 Answers
\d is a command of the interactive psql client. It is not part of SQL.
You can't execute this command over a JDBC connection.
2 Comments
L.rocky
can use java query create table sentence?
L.rocky
for example: result CREATE TABLE "public"."test" ( "id" int4 NOT NULL DEFAULT nextval('test_id_seq'::regclass), "name" varchar(255) COLLATE "pg_catalog"."default", CONSTRAINT "test_pkey" PRIMARY KEY ("id") ) ; ALTER TABLE "public"."test" OWNER TO "postgres";
You can also obtain table meta data Using Postgres java driver.
String tableName = "u_item";
ResultSet rs = metaData.getColumns(null, null, tableName.toLowerCase(), null))
Table name is converted to lowercase when Postgres stores its name in the system catalog.
[updated] have you checked this
3 Comments
L.rocky
I want result CREATE TABLE "public"."test" ( "id" int4 NOT NULL DEFAULT nextval('test_id_seq'::regclass), "name" varchar(255) COLLATE "pg_catalog"."default", CONSTRAINT "test_pkey" PRIMARY KEY ("id") ) ; ALTER TABLE "public"."test" OWNER TO "postgres";
L.rocky
I want query create table ,not is add create table
mayank
you may need to do some manipulation when you obtain result from PgResultSetMetaData
"\\d u_item"If you want a backslash in your statement, it needs to be escaped with another one.