How can a list of table's field names be queried from PostgreSQL?

Question

How can a plain text list of the field names of table be retrieved from PostgreSQL database?

mvp · Accepted Answer · 2013-01-09 03:22:09Z

1

Just query INFORMATION_SCHEMA.COLUMNS, like this:

SELECT
    column_name,
    data_type,
    character_maximum_length,
    ordinal_position
FROM information_schema.columns
WHERE table_name = 'mytable'

Better still, INFORMATION_SCHEMA is almost universally supported by all popular SQL databases, so this should work anywhere.

If you really want just dump plain text file recipe, you can execute this query using command line psql and save it as CSV or something like that.

answered Jan 9, 2013 at 3:22

mvp

118k15 gold badges132 silver badges155 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

How can a list of table's field names be queried from PostgreSQL?

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related