-general@postgresql.org
Subject: [GENERAL] metadata on a table
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
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
MG>(hopefully quick) comments below..
> From: subscri...@blackbrook.org
> CC: pgsql-general@postgresql.org
> Subject: Re: [GENERAL] metadata development
>
> Dara Olson wrote:
> >
> > Happy spring.
MG>Happy Spring..
> >
> > I am new to postgres/pos
Dara Olson wrote:
>
> Happy spring.
>
> I am new to postgres/postgis and am trying to figure out the best way
> to approach documenting metadata within postgres. Has there been
> anything developed to add FGDC or Dublin Core standard metadata
> records into postgres for each table within the datab
On Fri, 2009-03-27 at 10:44 -0500, Dara Olson wrote:
> I am new to postgres/postgis and am trying to figure out the best way
> to approach documenting metadata within postgres. Has there been
> anything developed to add FGDC or Dublin Core standard metadata
> records into postgres for each table
On Fri, Mar 27, 2009 at 9:44 AM, Dara Olson wrote:
> Happy spring.
>
> I am new to postgres/postgis and am trying to figure out the best way to
> approach documenting metadata within postgres. Has there been anything
> developed to add FGDC or Dublin Core standard metadata records into postgres
>
Happy spring.
I am new to postgres/postgis and am trying to figure out the best way to
approach documenting metadata within postgres. Has there been anything
developed to add FGDC or Dublin Core standard metadata records into postgres
for each table within the database? Is there any program t
I wrote:
> What userid are you connecting as under ODBC? Has it got privileges to
> any of the schemas? The information_schema views generally hide objects
> that you have no privileges for ...
In fact, looking closer, it looks like the schemata view only shows you
schemas that you are the *owne
"[EMAIL PROTECTED]" <[EMAIL PROTECTED]> writes:
> If I use pgAdmin and run "SELECT catalog_name FROM
> Information_Schema.Schemata" I get data back as expected.
> If I connect via ODBC and issue the same query I don't see any data.
What userid are you connecting as under ODBC? Has it got privil
Hi
I'm experimenting with PostgreSQL 8.3.0 on Windows connecting via ODBC. One
curiosity so far is this:
If I use pgAdmin and run "SELECT catalog_name FROM Information_Schema.Schemata"
I get data back as expected.
If I connect via ODBC and issue the same query I don't see any data. SQLFetch()
On Aug 30, 2007, at 2:45 PM, André Volpato wrote:
Hello,
I need constraint definitions like pg_indexes.indexdef , in order
to drop / create them on the fly.
BTW, where can I find a complete doc about Postgres Metadata ?
- AV
The system catalogs are in the manual appendix. However, for w
Hello,
I need constraint definitions like pg_indexes.indexdef , in order to
drop / create them on the fly.
BTW, where can I find a complete doc about Postgres Metadata ?
- AV
---(end of broadcast)---
TIP 1: if posting/reading through Usenet, pl
On Mon, Dec 11, 2006 at 06:19:33PM -0700, Lenorovitz, Joel wrote:
> Greetings,
>
> I was wondering if it's possible to get any of the metadata from the NEW
> and OLD constructs in a trigger or view rule? Specifically, I'd like to
> get the column name or identifier anywhere the new record differs
Greetings,
I was wondering if it's possible to get any of the metadata from the NEW
and OLD constructs in a trigger or view rule? Specifically, I'd like to
get the column name or identifier anywhere the new record differs from
the old record (i.e. NEW.column_X <> OLD.column_X). Any advice would
Renaud Tthonnart writes:
> Could someone give me some explaination about the metatable(s) of
> PostgreSQL?
> Where is it and is there to find in it?
A good way is to start psql with "-E", it'll then show you the queries
it makes from the metatables when you do things like "\d table".
Dan
--
15 matches
Mail list logo
