Is there a way to ask for the columns info using the `Propel::getConnection()` ?

Chemaclass

Is there a way to ask for the columns info using the Propel::getConnection() ?
I tried exec('\d+ table_name'); but it’s not working (it says syntax error).
I tried also using this query, but the output is not the columns but metadata that I am not really interested…

SELECT *
FROM information_schema.columns
WHERE table_schema = 'public'
AND table_name = 'table_name';

I would like to get the column names from a given table in a specific schema using a Propel connection. Does anyone has other ideas or if this is possible? 🤔

Thanks in advance!

Alberto Reyer

Propel uses PDO under the hood and \d is a command specific to the DB engine and therefore not supported by PDO.

The column names can be retrieved like (maybe you have overseen them with all the meta data returned by your query):

SELECT COLUMN_NAME
FROM information_schema.columns
WHERE table_schema = 'public'
  AND table_name = '<table_name>';

Alberto Reyer

Propel uses PDO under the hood and \d is a command specific to the DB engine and therefore not supported by PDO.

The column names can be retrieved like (maybe you have overseen them with all the meta data returned by your query):

SELECT COLUMN_NAME
FROM information_schema.columns
WHERE table_schema = 'public'
  AND table_name = '<table_name>';

Chemaclass

oh gosh, you’re totally right!
I need to SELECT COLUMN_NAME of course!
Thank you @UL6DGRULR 🙇🏼