I am trying to look into the information_schema.columns table but I can't
seem to find it using the normal connector:
DBHR = Sequel.connect('postgres://rich@localhost:5432/rich')
fieldnames = DBHR[:columns].where(table_name: 'airports_gps').get(:
column_name)
This is what I'm trying to achieve:
select column_name from information_schema.columns where table_name =
'airports';
I'm not sure how to get into that database and table. *psql* is fine with
the query, as is another client application.
I also found this: *PostgreSQL now uses the pg_* system catalogs instead
of the INFORMATION schema.*
I'm just trying to get fieldnames from a table, and I'm thinking there's a
more direct way than abstracting to a *DB.do <<*...
Any insight appreciated. Cheers
--
You received this message because you are subscribed to the Google Groups
"sequel-talk" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
To view this discussion on the web visit
https://groups.google.com/d/msgid/sequel-talk/66f4953a-2f17-4e1b-bd50-99ab011ca26b%40googlegroups.com.
