CODEWITHSUNDEEP
postgresqlpostgresql-9.5
B3n Sp1ndl3r
B3n Sp1ndl3r

Reputation: 35

too many column names were specified

how can i deal with that error? 

ERROR:  too many column names were specified

i can't figure out what i have to change to make this work. Is there really too many columns in my CREATE statement or is this in the AS SELECT that goes wrong? 

CREATE TABLE planification_finale_asset2_test
(   nom,
nom_court,
serveur,
scheduled_backup,
schedule,
retention,
groupe,
remote_access,
alias,
parallelisme,
storage_nodes,
client_OS_type,
version_networker,
savesets,
ALIAS_1,
ALIAS_2,
APPLICATION,
ENVIRONNEMENT,
environnement_global,
IMPACT,
CLIENT_OPERATIONNEL,
TYPE,
SITE,
COMPOSANT_DE,
COMPOSE_DE ,
ETAT,
POIDS,
EQUIPE_EXPLOITATION,
debut_sauvegarde,
groupe_actif,
intervalle,
clones,
retention_policy,
calendrier,
commentaire,
volume_sauvegarde,
volume_externalise,
volume_replique,
"3P2I") AS
SELECT t1.*, CONCAT(groupe, ' status ', scheduled_backup) AS etat_groupe,
    CONCAT(groupe, ' status ', groupe_actif) AS etat_groupe_actif,
    t3.volume_sauvegarde, t3.volume_externalise, t3.volume_replique
from planification_client_biens_group_test t1
LEFT OUTER JOIN volumetrie_1_jour t3
    ON t1.nom LIKE CONCAT(t3.client, '%') AND
       t1.serveur = t3.serveur_court;

Thanks for your help!

Upvotes: 1

Views: 481

Answers (1)

Gowdhaman008
Gowdhaman008

Reputation: 1323

Please try with the following query

SELECT t1.*, CONCAT(groupe, ' status ', scheduled_backup) AS etat_groupe,
    CONCAT(groupe, ' status ', groupe_actif) AS etat_groupe_actif,
    t3.volume_sauvegarde, t3.volume_externalise, t3.volume_replique
into planification_finale_asset2_test from planification_client_biens_group_test t1
LEFT OUTER JOIN volumetrie_1_jour t3
    ON t1.nom LIKE CONCAT(t3.client, '%') AND
       t1.serveur = t3.serveur_court;

It will load the data to your table planification_finale_asset2_test.

Upvotes: 1

Related Questions