Categories

JavaScriptPHPHTMLCssPythonWordPressWeb developmentLinuxMySQLAndroidWindowsJavaC++ / C#LayoutReactUbuntuYiiDjangoProgramming1C-BitrixLaravelSystem administrationTelegramJSONDebianPostgreSQLIOSGoogleHtaccessWindows ServerGitMacOSGoogle ChromeCMSWooСommerceBootstrapNginxSQLUnityAPI
Make a leaderReport
G
G
gilbert02021-06-02 20:52:34
PostgreSQL
gilbert0, 2021-06-02 20:52:34

How to solve the problem with an anonymous block?

Create an anonymous block or subroutine to display values ​​from given columns in a given table. Set the column names as a local variable (or input parameter) - an array. Table name - as the second local variable (input parameter). Provide for the correct transfer of database object identifiers using the FORMAT or QUOTE_INDENT function.

Reply
Answer the question

Answer the question

In order to leave comments, you need to log in

0 answer(s)
Similar questions
K
Klein Maximus2016-12-09 20:51:56
How to bind an array of values ​​in an IN condition when using PDO? 3Reply
S
Steve2021-01-15 10:53:18
Subquery must return only one column error? 1Reply
P
postgresdev2019-05-15 11:56:58
How to dump PostgreSQL database to local machine? 1Reply
A
Artem00712019-05-20 13:01:10
How to install postgis on specific version of postgresql in homebrew? 1Reply
O
Oklick2016-12-23 02:05:16
How to get records where params ->> 'price' is greater than a given number in PostgreSQL(jsonb)? 2Reply

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question