metadata on a table

Поиск
Список
Период
Сортировка
От Malm Paul
Тема metadata on a table
Дата
Msg-id 2CF53313EAE78542876F7C9689F9F725045531B1@corpappl747.corp.saab.se
обсуждение исходный текст
Ответ на Re: creating a table based on a table in stored in another database  (Scott Mead <scott.lists@enterprisedb.com>)
Ответы Re: metadata on a table
Список pgsql-general
Дерево обсуждения
Hi,
I'm trying to read the metadata from table to create the same sort of table in another database, using java.
 
This is how I do it today

quwstion = "SELECT  * FROM table"
stmnt = dbConnection.prepareStatement(question);

rs = stmnt.executeQuery();

ResultSetMetaData rsMetaData = rs.getMetaData();
int numberOfColumns = rsMetaData.getColumnCount();
System.out.println("resultSet MetaData column Count=" + numberOfColumns);
int precision = rsMetaData.getPrecision(1);
String columnTypeName = rsMetaData.getColumnTypeName(1);
String name = rsMetaData.getColumnName(1);
String classname = rsMetaData.getColumnClassName(1);

The first object is the primary key with the name "fid",
columnTypeName = int4
 
I can see in the original table that fid has the type serial, which is an int4 (pgAdmin).
But when I create the table in the other database I would like to create it as serial not just int4, how can I know that it is a serial? 
 
Kind regards,
Paul

В списке pgsql-general по дате отправления: