On Tue, Oct 11, 2011 at 6:37 PM, Chris Travers chris.trav...@gmail.com wrote:
On Tue, Oct 11, 2011 at 4:33 PM, Raymond O'Donnell r...@iol.ie wrote:
On 12/10/2011 00:24, J.V. wrote:
pg_catalog table does not exist.
It's not a table, it's PostgreSQL's version of the information_schema
I need to be able to query for all primary keys and save the table name
and the name of the primary key field into some structure that I can
iterate through later.
How would I go about this? I want to hard code the number of tables and
be able to iterate through some structure to get the
On 10/11/11 2:16 PM, J.V. wrote:
I need to be able to query for all primary keys and save the table
name and the name of the primary key field into some structure that I
can iterate through later.
How would I go about this? I want to hard code the number of tables
and be able to iterate
On 10/11/2011 05:16 PM, J.V. wrote:
I need to be able to query for all primary keys and save the table name
and the name of the primary key field into some structure that I can
iterate through later.
How would I go about this? I want to hard code the number of tables and
be able to iterate
pg_catalog table does not exist.
This is a solution for PostgreSQL 8.4.
If you know of a way I can get all primary key fields or have a query
that will work in 8.4, please help. I have done a lot of research and
cannot find a simple way.
J.V.
On 10/11/2011 3:29 PM, John R Pierce wrote:
On 12/10/2011 00:24, J.V. wrote:
pg_catalog table does not exist.
It's not a table, it's PostgreSQL's version of the information_schema
catalog:
http://www.postgresql.org/docs/8.4/static/catalogs.html
Ray.
--
Raymond O'Donnell :: Galway :: Ireland
r...@iol.ie
--
Sent via pgsql-general
On Tue, Oct 11, 2011 at 4:33 PM, Raymond O'Donnell r...@iol.ie wrote:
On 12/10/2011 00:24, J.V. wrote:
pg_catalog table does not exist.
It's not a table, it's PostgreSQL's version of the information_schema
catalog:
http://www.postgresql.org/docs/8.4/static/catalogs.html
Not quite.
On 10/11/11 4:24 PM, J.V. wrote:
pg_catalog table does not exist.
This is a solution for PostgreSQL 8.4.
pg_catalog is a schema that has about 150 views and tables in it.
pg_tables is one such, as is pg_indexes (these two are both views)
you do realize, the primary key might not BE a
Hi,
On 12 October 2011 08:16, J.V. jvsr...@gmail.com wrote:
I need to be able to query for all primary keys and save the table name and
the name of the primary key field into some structure that I can iterate
through later.
psql -E is your friend here. Then use \d table and you get several