Highlighted

Using USE in ColdFusion with Postgres

Explorer ,
Dec 15, 2015

Copy link to clipboard

Copied

Postgres doesn't have the USE directive, unlike SQL Server or MySQL. There is the \c <database> command, but that only works in the psql REPL. Is there an alternative to USE that can be used with cfquery in Postgres? We would be using this with CF 11.

TOPICS
Database access

Views

364

Likes

Translate

Translate

Report

Report
Community Guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more

Using USE in ColdFusion with Postgres

Explorer ,
Dec 15, 2015

Copy link to clipboard

Copied

Postgres doesn't have the USE directive, unlike SQL Server or MySQL. There is the \c <database> command, but that only works in the psql REPL. Is there an alternative to USE that can be used with cfquery in Postgres? We would be using this with CF 11.

TOPICS
Database access

Views

365

Likes

Translate

Translate

Report

Report
Community Guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
Dec 15, 2015 0
Most Valuable Participant ,
Dec 16, 2015

Copy link to clipboard

Copied

Looks like this question is getting a little bit more attention over on StackOverflow: http://stackoverflow.com/questions/34292834/using-use-in-coldfusion-with-postgres.

Likes

Translate

Translate

Report

Report
Community Guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
Reply
Loading...
Dec 16, 2015 0